Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Primary index with filter; can this be programmed???
Message
 
To
17/08/1999 08:47:32
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00254466
Message ID:
00254503
Views:
23
Wim,

There is no way to programatically create a filtered Primary index.

It is not good desing to do that anyway as you create a sitauation where the recall of an existing record could cause data integrity to be lost. Instead use surrogate pk's that are meaningless and never reuse a value for the PK. This way you don't care what the PK values are on the deleted records because you will never use them again anyway.

You can use candidate keys for those fields that must be unique.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform