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