Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select into array with memo field
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00714320
Message ID:
00714330
Views:
10
In VFP7 SP1, I do not get this error when doing this. I have 4200 pluse records being selected into an array. As a test, I stuffed almost 19,000 characters into the memo field of one of these records complete with a bunch of CRLFs. I have no such errors. How long is your string? How many records are being selected into your array?

>Are there known limitations of using a sql select into an arry where one of the select fields is a memo? I didn't have any problems with this code until I entered a long string that has CRLF in it. Now I get a String to Long To Fit message:
>
>
>SELECT ALLTRIM(questdesc),IIF(isRequired,"1","0"),ALLTRIM(STR(recordid)) ;
>	FROM curquest INTO ARRAY latemp1
>
>
>where questdesc is a memo field.
>
>Kirk
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform