Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append from text field to memo field
Message
From
15/06/2005 08:02:45
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows NT
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01023393
Message ID:
01023424
Views:
13
SNIP
>>
>>thisform.edbHistory.value = thisform.edbHistory.value + thisform.txtUpdate.value
>>
>>That work?
>>
>>Terry
>
>It will work. I'm worried about the character string getting too long? The contents of the history memo field could get quite long....

As others have said, the length itself should not be a problem.

But you need to be aware of how Memo fields work.
Memo field data is stored in the table's .FPT file, and each time that you add/replace data in a Memo field and save it the mechanism 'invalidates' the area where the original information was stored and then adds a new 'block' to the end of the file to hold the new/revised data.

When such changes are done frequently to the same record, even over time, this causes "memo bloat" and it is possible for a .FPT file to grow to the 2GB limit while holding actually very little data (in the extreme case).

A PACK can be use to eliminate the memo bloat as long as there is at least 1 deleted record in the table. Otherwise a PACK MEMO should work regardless.

cheers
Previous
Reply
Map
View

Click here to load this message in the networking platform