>I need to prepend a text string to a memo field. The routine works perfectly as long as the memo isn't empty. When it is, no text is added. What am I missing? Do I need to add an EOF character to the string? If so, what CHR() value is it?
I would just use:
REPLACE MemoField with SomeContents
To add to the beginning of the previous contents, you can add a new line with chr(13) + chr(10):
replace MemoField with SomeContents + chr(13) + chr(10) + MemoField
HTH,
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)