Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MLINE(comment,1) in cursor truncates memo field
Message
 
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:
00192878
Views:
14
>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

You're probably overlooking the fact that the first returned line in a SELECT statement determines the field width for the rest of the lines.

Try SELECT PADR(MLINE(comment, 1), SET('MEMOWIDTH')) AS comment...
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform