Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is the Pack command really dangerous?
Message
De
12/12/2000 11:53:08
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00451943
Message ID:
00452295
Vues:
50
Hi Dave.

>You mentioned that you also recreate your indexes. Is this something that I should be doing every time I run PACK?

PACK will automatically recreate the indexes for you. However, since it does that based on the definitions of the indexes in the header of the CDX file, that assumes the CDX file is in perfectly good shape. The safe approach is to blow away and recreate the indexes. However, note that this may take significantly longer to perform, especially in VFP 6 SP 3 or later with large tables, because VFP can REINDEX faster than individual INDEX ON commands can be executed.

In 17 years of working with xBase languages, I've never had a problem with PACK, nor have I ever heard of anyone actually having a problem. I suspect this is one of those theoretical issues.

Doug
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform