Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is the Pack command really dangerous?
Message
From
12/12/2000 11:53:08
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00451943
Message ID:
00452295
Views:
45
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform