Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Ignoring deleted records in a SEEK
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00345465
Message ID:
00345510
Views:
15
I would think this is possible, but I have never experienced it.

>Well, all other searches complete fine...would a corrupt index find other records but not find others? As far as the second suggestion, I have put SET DELETED ON in the load of the search form that I'm using. Thanks for your reply:)
>
>>
>>Two thoughts (all I'm capable of in a day):
>>
>>1. Your index has become corrupt. I use Stonefield Database Toolkit for my reindexing.
>>
>>2. Maybe you are using a form's private data session, and SET DELETED is scoped to the data session. In other words, SET DELETED ON in your main programs isn't enough. You have to SET DELETED ON for each form. This is typcially done in the class's Load() method.
Chris McCandless
Red Sky Software
Previous
Reply
Map
View

Click here to load this message in the networking platform