Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is the Pack command really dangerous?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00451943
Message ID:
00452365
Views:
44
>>Well, I'm curious now. Does PACK reclaim any space originally occupied by the table as it is working, or does it need free space as large as the non-deleted records?
>
>I don't think so, AFAIK, it moves all non-deleted records to a Temp file. Its renames the old table, renames the new table to the old table name and destroys the old temp table. If it does anyhting "partial" in between like I think you're saying I really doubt it.

You're exactly right. It copies the non-deleted record to a temporary file, deletes the original, then re-names the temporary. It's easy enough to check. Simply look at the Date Created date/time stamp on the file. It is possible (and this is the only problem I've ever run into with PACK) that there might not be sufficient disk space to perform this operation. If the table resides on a LAN, the temporary file goes to whatever drive/directory that VFP stores its temp files. There may be plenty of space on the network, but the user still might not be able to perform the operation if their local drive is close to full.
George

Ubi caritas et amor, deus ibi est
Previous
Reply
Map
View

Click here to load this message in the networking platform