General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only