Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Primary key
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00903491
Message ID:
00903980
Views:
11
Thanks for all the helpful answers! To summarize, there are 6 ways to tackle my issue:

1. recycle deleted record
2. pack after delete
3. replace primary key value of deleted record
4. add filter to primary index
5. change primary index to regular index
6. use surrogate key as primary index field

In my particular case, i probably will go for #3 for now, and i think i will see if i could use a surrogate primary key next time around.

Thanks again all!
Previous
Reply
Map
View

Click here to load this message in the networking platform