General information
Category:
Coding, syntax & commands
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
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