Bob ---
Try using the second parameter of MLINE() explicitly using the _MLINE system variable...for example:
nCurrMLine=_MLINE
SELECT MLINE(comment,1,_MLINE) FROM hdefects INTO CURSOR curTemps WHERE .....
>If I do this:
>
>? MLINE(comment,1) && where comment is a memo field
>
>I get the first line of the memo field, as I expected.
>
>If I do this:
>
>SELECT MLINE(comment,1) FROM hdefects INTO CURSOR curTemp WHERE .....
>
>I get the first few characters of the memo line but not the entire line. SET MEMOWIDTH doesn't seem to have anything to do with the length of the returned line. What am I overlooking? TIA
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05