Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unique Key Violation
Message
 
 
To
24/07/1999 16:03:54
Antonio Gubaira
Ingenieria Y Sistemas
Valencia, Venezuela
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00245748
Message ID:
00245785
Views:
11
You can't because deleted records are still in the table until you issue a pack. The solution is not to reuse primary keys. This is must simpler anyway.

>When designing a table I create a primary key. Afterwards I design a form to input data to the table indexed by the primary key. When adding a record to the table and deleting it; I cannot reuse the same key because VFP´s error handling engine submits the message "unique key violation". My DELETED setting is ON. Why does this happen and how can I work around the problem.
>
>Thanks
Previous
Reply
Map
View

Click here to load this message in the networking platform