>Hello,
>
> I've been bumping into same problem in two areas lately, and I thought it was something that VFP was done with (I was convinced for awhile that SP4 busted something on my setup).
>1) I wrote a loop through an object to create a fieldlist and a varlist for an SQL statement string to use with ado connection.
>The fieldlist and varlist collector statements were something along the lines of: lcFieldList = lcFieldList + obj.arow(i)
>
>2) I tried to set a custom property (a field inclusion list) to a string of about 500 chars.
>
>In both these cases, the statements broke because strings grew to > 256 chars. (I guess), so I had to break them up into separate statements. In the first case, I collected the partial strings into an array, adding an array element whenever the current string was going to exceed 256 chars. Then I concatenated all the element contents together to get the full string.
>In the second case, I had to break up the list, as in
>lcSubList1 = "etc,etc,etc,etc,...."
>lcSubList2 = "etc,etc,etc,etc,...."
>lcSubList3 = "etc,etc,etc,etc,...."
>lcFullList = lcSubList1 + lcSubList2 + lcSubList3
>
>Is there a better way to do this type of stuff with extra long strings? I was under the impression that VFP was over this barrier, but I guess not. If not, is it in VFP7 or the wish list for a future version?
>
>Thanks
>Rod Poujade
>Montreal, Canada
I'm confused about your question. Using FILETOSTR() you can end up with strings that are MUCH bigger than 256 characters.