>Cetin
>
>>>Are you sure making string longer than 255 would make it a memo in SQL ? <<
>
>C(254) is the max char field size in a VFP table or cursor, so a string longer than that will be a memo.
>
>If the first row has a calculated field length <255 then it may be expressed as a character field with truncation for any subsequent fields that are longer. Hence the PADR().
>
>Regards
>
>JR
John,
I accidentally happen to know max char field size. I was referring to :
IF LEN(lcString)<255
lcString=PADR(lcString,255)
ENDIF
RETURN lcString
I just couldn't get how this would work. W/o structure of SQL is not prepared as 'memo' for the field my trials return 'String too long to fit'. What am I doing wrong ? Would you provide a sample. Thanks.
Cetin