Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CURSOR Experiencing Memo Bloat
Message
From
19/07/2006 10:26:18
 
 
To
19/07/2006 08:03:46
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
01136610
Message ID:
01137603
Views:
18
Hi - just passing by - has anyone tried pack memo? Or am I just getting in the way?

>Ah ha! Many thanks :)
>
>
>>You have to open table exlusivelly otherwise FoxPro will not reuse memo space.
>>
>>>
>>>CLEAR
>>>
>>>CREATE TABLE bloattest (mymemo m)
>>>APPEND BLANK
>>>replace mymemo with replicate("X", 1000)
>>>USE
>>>DIR bloattest.FPT to FILE bloat_test.txt
>>>
>>>USE bloattest
>>>replace mymemo with replicate("X", 1000)
>>>USE
>>>DIR bloattest.FPT  to FILE bloat_test.txt
>>>
>>>USE bloattest
>>>replace mymemo with replicate("X", 1000)
>>>USE
>>>DIR bloattest.FPT  to FILE bloat_test.txt
>>>
>>>USE bloattest
>>>replace mymemo with replicate("X", 1000)
>>>USE
>>>DIR bloattest.FPT to FILE bloat_test.txt
>>>
>>>
>>>I get this result:
>>>
>>>
>>>BLOATTEST.FPT
>>>
>>>     1536 bytes in 1 file.
>>>
>>>     2560 bytes in 1 file.
>>>
>>>     3584 bytes in 1 file.
>>>
>>>     4608 bytes in 1 file.
>>>
>>>
>>>In other words, even though I am replacing the exact same size of memo text it seems to be increasing the FPT file nonetheless. Any ideas?
>>>
>>><snip>
I ain't skeert of nuttin eh?
Yikes! What was that?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform