Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
To PACK, or not to PACK that is the question
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00017947
Message ID:
00018024
Views:
49
>>The question also is who much diskspace is enough for Fox temp files >>during a PACK? 1/2x or 1/3x the size of the DBF? Also, could U just >>use diskspace() before attempting a pack? Please keep this thread >>alive if you confirm this is a problem.

I believe that you need something like 3 times the size of the table being packed. FoxPro copies the original table without the deleted records, deletes the original, and then renames the copy (hence the reason PAul lost his whole table when he ran out of disk space).

For this reason, PACK was often done manually in pre-Visual FoxPro i.e. the above steps were performed with a custom program, allowing the programmer to recover in the event of an error. However, this procedure will likely damage referential integrity etc :(

Matt McQueen.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform