Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Understanding Indexes
Message
 
 
To
06/08/2009 15:42:32
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01416559
Message ID:
01416561
Views:
92
>I'm reasonably clear on how VFP uses indexes to prevent duplicate data entry but found out that it apparently applies such index controls to deleted records. Is there a way to set up VFP indexes to bypass or ignore deleted records? All responses are appreciated.

You may try to add a filter on NOT DELETED() for the index.

Chose BINARY for the type of such index.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform