Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What is a FPT File
Message
From
27/11/2001 11:23:02
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
 
To
27/11/2001 11:17:44
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Miscellaneous
Thread ID:
00586267
Message ID:
00586379
Views:
13
>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
Map
View

Click here to load this message in the networking platform