Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MLINE(comment,1) in cursor truncates memo field
Message
From
01/03/1999 16:56:44
 
 
To
01/03/1999 16:51:52
Bob Tracy
Independent Consultant
Driftwood, Texas, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00192872
Message ID:
00192876
Views:
21
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
Previous
Reply
Map
View

Click here to load this message in the networking platform