Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
>Hi Robin
>
>I thought I would add this point to all the other replies: The problem with memo fields in VFP is that when you replce the contents of a memo field the new data is appended to the FPT file and the record pointer updated to the new data location but the original memo field data is still in there!
>
>You cannot see the old memo field data but it still takes up diskspace until you PACK the file. This creates FPT file bloat and is why you need to PACK regularly.
>
>HTH
>
>Jos
Jos,
I never knew that. I wonder why it's that way as opposed to changing the value of the memo on the appropriate record? If I designed my tables that way I would be laughed out of the testing area! Must be missing something...
Renoir
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only