Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Uniqueness of index error
Message
 
À
07/09/1999 14:35:33
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00262089
Message ID:
00262092
Vues:
14
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?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform