Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Handling Corrupt Indices
Message
From
30/10/1998 10:04:15
 
 
To
28/10/1998 13:55:32
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00151798
Message ID:
00152792
Views:
25
Hi John.

>Physically delete the CDX file then open the table (you'll get a structural index not found error if it's the structural cdx...ignore it) -- then recreate the indexes either throught a PRG script or manually.

That won't necessarily work -- if the table belongs to a database and you've defined a primary key for the table, VFP refuses to open the table if the index is missing or damaged. The only solution in that case is to VALIDATE DATABASE RECOVER and tell VFP to remove the primary key for the table (as well as the other indexes), then recreate them. One complication: VALIDATE DATABASE RECOVER won't work in a run-time environment, so you can't do this at a client site.

Doug
Previous
Reply
Map
View

Click here to load this message in the networking platform