Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Handling Corrupt Indices
Message
De
30/10/1998 10:04:15
 
 
À
28/10/1998 13:55:32
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00151798
Message ID:
00152792
Vues:
26
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform