Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Primary Keys when deleted can't be reused untill pack
Message
From
06/05/2000 20:06:34
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Primary Keys when deleted can't be reused untill pack
Miscellaneous
Thread ID:
00367026
Message ID:
00367026
Views:
53
How are developers handling the problem where a primary key and data record is added to a table. The user decides to start the record over so they delete the record. When they start to add the record again with the same key, they will get a duplicate key message because the key, although deleted, is still in the index, until I pack the file. One idea would be to change the key when I delete the record. Is there a better approach anyone is using.
Next
Reply
Map
View

Click here to load this message in the networking platform