How you call this SQL? '&' or PRG file compiling?

In fact, SQL SELECT command may contain much more that 4K of characters. Never have had a problems with that in our query builder.

Try to add chr(13) + chr(10), not just chr(13) to separate lines.
In addition, I run such queries ONLY by putting them into PRG file, compiling and than running. Because VFP '&' (macro) does not works in many cases for multi-line commands.
Finally, you do not need to separate all items. Just keep 1 line less than 255 characters.

>I have an intermediate cursor with 192 fields. I need to 'SQL' sum fields 7-192. First I did this :
>

lcPattx = ''
>for ix = 1 to 186
> lcPattX = lcPattx + ;
>   ',sum(T'+padl(ix-1,3,'0')+') as T'+padl(ix-1,3,'0')
>endfor
>select f1,f2,f3 &lcPattX from ...

Then this :
>

lcPattx = ''
>for ix = 1 to 186
> lcPattX = lcPattx + ;
>   'sum(T'+padl(ix-1,3,'0')+') as T'+padl(ix-1,3,'0')+', ;'+chr(13)
>endfor
>_cliptext = lcPattX

and pasted the code. I even tried removing 'as ...' part. Total commandline length is 4199 at max. Both approaches crash VFP. Any ideas other than not using SQL ? TIA
>Cetin