FoxPro->SQLServer key violation 
Author Message
 FoxPro->SQLServer key violation

(follow-up)
So I ditched the keys, imported into SQLS, created a non-unique index on
userid. Then did a query in VFP to find duplicates of userid. I found a
bunch of them, and in all cases accented characters were converted to US
equivalents.

Does this help?



Tue, 29 Jun 1999 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. ERROR: ODBC/SQLServer Primary key violations

2. INSERT INTO TABLE KEYED ONLY ON IDENTITY COLUMN RESULTS IN KEY VIOLATION (6.5)

3. Violation of PRIMARY KEY constraint Cannot insert duplicate key in object

4. Paradox Key Violation - changing a keyed field

5. Preventing Key Violation for duplicate keys

6. Reordering of key fields leads to key violations (Pdox 5.0)

7. Reordering of key fields leads to key violations (Pdox 5.0)

8. Unable to Load xml file ASP->VBScript->XML->SQLServer

9. SQLServer <---> SQLServer Link

10. SQLServer 7.0 -> SQLServer 2000 migration with ASP

11. Sqlserver->ODBC->ASP Please HELP !!!


 
Powered by phpBB® Forum Software