Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
PACK - what to expect?
Message
From
13/01/2003 14:52:47
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00740999
Message ID:
00741150
Views:
17
Hey SB,

You are, of course, right! (I just checked :) So its even worse than I thought because if you add some data to an existing memo field then it re-writes the entire memo data again at the end of the FPT - but this does make sense in a way since how else to handle data deletions etc. So, the PACK just removes all the old redundent copies of the memo field.

Thanks.

>Jos,
>
>A memo field is always stored in one piece.
>
>< snip >
>>In addition, old memo data is not removed from the memo field when it is replaced with new data. The old data is still in the FPT file too. So a PACK MEMO does two things (a) remove all the old data and (b) rejoin each memo fields seperate pieces. But still, how this all ends up on the HDD is up to the OS and state of the HDD.
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform