Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Missing Data Records
Message
 
 
To
21/08/2002 16:22:40
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00692198
Message ID:
00692215
Views:
19
Pat,

>We are seeing 10-15 records a day failing the LOCATE when they later need to be edited. We know the records were not deleted, an INDEXSEEK on a unique field returns .t., and a manual SEEK places the cursor on record in the table that doesn't match the SEEK criteria. This seems to indicat that a record appears to be in the index but not in the table.

This sounds like you have a corrupted CDX file. You need to rebuild it.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform