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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement