Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Corrupt CDX suddenly
Message
From
03/11/2004 11:50:18
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 3
OS:
Windows '98
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00957602
Message ID:
00957682
Views:
16
>>Well that's news to me. I thought Pack just permanently removes rec's >>marked as deleted. If that's the case, and you haven't reindexed, then you >>WILL get the same indexing problem everyday. 'sup to you

My understanding is that pack does the following

COPY TO WITH PRODUCTION FOR !DELETED()
DELETE FILE
RENAME TO

Therefore it is mightier that the REINDEX!

The Hackers Guide to VFP7 states:

"PACK permanently removes all marked records. What it actually does is copy all the unmarked records into a new file and then rename the new file. (The table is also reindexed.) Because PACK does this behind the scenes, there is a small chance for data loss if your system crashes during a PACK."

Regards

Gary.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform