Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
PACK - what to expect?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00740999
Message ID:
00741100
Views:
29
>>I hazard that many many people expected that a PACK would PACK - i.e. copy the
>>table, REINDEX it, and 'optimized' the FPT. I bet many "file maintenance"
>>routines are based pricisely on this.
>
><*shrug*> And I'll bet precisely the other way: that anyone who wants their tables reindexed will explicitly call either REINDEX or DELETE TAG ALL/INDEX ON. I don't see any need to read more into Permanently removes all records marked for deletion in the current table and reduces the size of a memo file associated with the table than is stated.

First let me CORRECT - I erred when I said the FPT was UNchanged. I had expected that the FPT would have been re-written (thus defragged) if PACK did anything to it.
A re-run (after adding more content to more memos) showed that ACTION DID HAPPEN - just not a re-copy (thus defrag) of the FPT. Fragment counts were reduced by a PACK MEMO.

SHRUG back at ya... I wouldn't want to read more into "When you use PACK, Microsoft Visual FoxPro copies all records not marked for deletion to a temporary table. After PACK is finished executing, Visual FoxPro deletes the original table from disk and renames the temporary table with the original table name. either!

Following your example, though, I guess I shouldn't read more into the SET REFRESH words "Determines whether and how often a Browse window is updated with changes made to records by other users on the network. either. In other words, the statements written at the top of the Help, right under the title, RARELY describe the facts. How is one to know which do and which don't??

cheers
Previous
Reply
Map
View

Click here to load this message in the networking platform