Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Uniqueness of index error
Message
 
 
To
07/09/1999 14:35:33
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00262089
Message ID:
00262092
Views:
13
Hi Mary-Ann.

Some ideas:
- are you sure the data in the column has no duplicates
- there might be some deleted records in the table. You must pack the table to remove. Uniqueness is enforced for deleted rows as well since they are still in the table and could possibly be "undeleted".

>trying to create a database with 2.6 tables. I'm able to put them in the container, but then if I try to change the 'main' file's index to 'Primary', I get "Uniqueness of Index IndexName is violated". I can't set up the relationships. The only way it will work is if I delete all the records. But when I do that, (obviously I'm going to need the data) and try to append from a copy to add the records back in, it stops at about a third of the way through and gives me the same "uniqueness of index" error. What am I doing wrong?
Previous
Reply
Map
View

Click here to load this message in the networking platform