George,
Here's the basic idea of pre-padding to prevent "memo bloat":
CREATE TABLE c:\temp\test (Mem M)
APPEND BLANK
REPLACE Mem WITH SPACE(100000)
FOR i = 1 TO 1000
REPLACE Mem WITH STUFF( Mem, 1+ 100 * (i-1), 100, PADR( REPLICATE( TRANSFORM( i), 100), 100))
ENDFOR
USE
I was just wondering if this was common knowledge (with lots of examples) or new ground?
>>Any good examples for dealing with the "memo bloat" problem? I'm specifically looking for more info about the pre-padding technique that keeps the memo size to a minimum and avoids the allocation of more space as values are added to the memo.
>
>Claude,
>
>I don't know of any good examples in this area, however, but PACK MEMO will remove the unused space.