Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Rebuild index
Message
De
01/10/2012 17:24:56
 
 
À
01/10/2012 17:20:21
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01554080
Message ID:
01554086
Vues:
54
REINDEX may not work. If the corruption is in the file header, VFP won't accurately know how to recreate the index. The fields used in the index are stored in the header.

A better way is to delete the index then recreate it from scratch. But that has its own drawbacks as it will delete referential integrity settings in the DBC if you're using them. So.. save those first or just recreate them in the index program. Note that you may get an error when you delete the index, but you can ignore that and the index will still be created properly.


>That's a good first step, but then you have to get him to run REINDEX on the affected table. That's because the CDX you send only has information about your table, not his.
>
>Hopefully you have a REINDEX function in your app. If not, he can run it from a VFP command window, or you can create a little .EXE file that REINDEXes.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform