Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement