Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Violating key
Message
De
08/12/2004 11:08:42
Jim Winter
Jim Winter Consulting
Hinesburg, Vermont, États-Unis
 
 
À
08/12/2004 10:41:23
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Versions des environnements
Visual FoxPro:
VFP 6
Database:
Visual FoxPro
Divers
Thread ID:
00967754
Message ID:
00967770
Vues:
14
Chistine,

If the index is marked as a Primary or Candidate key you can't reuse values even if they are marked for deletion. If you use integers as your key field, you can use autoincrementing fields in VFP 8 or setup a routine to grab a value from a key table and then increment it in the key table in earlier versions.

Or, better yet, switch to GUIDs.

HTH,

>I am using the VFP tables. I have a situation where, you enter a record and the user enters a unique key. The record is then deleted. Later another record with the same key is entered. an error occurs regarding the uniqueness of the key. Why does this error occur. When I browse the VFP table I do see that the old record is there and marked for deletetion. Is there a way to avoid this problem with out packing and reindexing the table?
>
>Thank you in advance
>Christine
Jim
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform