Hi,
<snip> or larger than what is currently in the memo field
If the "larger than" exceeds the block size, all the memo data is copied to the end of the file and this is what causes the bloat.
A bug was reported a while ago where if the data was on a block boundary and replaced, it would cause bloat, but I haven't tested it lately.
BTW we abandoned using memos for text based storage a while ago, especially in high load scenarios under the novell environment, as there were too many failures.
>Hi
>
>I have understood that if I open a file containing a memo field in EXCLUSIVE mode that when I replace the memo field with a new content that if I ensure the new content is the same size or larger than what is currently in the memo field that I will avoid memo field bloat. However, I am still getting memo field bloat even when I do this. I am replacing my memo field as follows:
>
>
>REPLACE my_file.memo_field WITH PADR( m.New_Memo_Data, MAX( LEN( my_file.memo_field ), LEN( m.New_Memo_Data ) ), " " )
>
>
>Why do I still get memo field bloat?
Regards N Mc Donald