General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2000 Server
>>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only