What is crash? Which error message you got?
As I told, I do not use '&' for such long SQL because it does not works.
Split it to parts 255 chars max in each line by ' ;'+CHR(13)+chr(10). Than wrote it into temporary PRG file. Compile. Run. Should work. Unless VFP have problems with such big number of 'SUM's in query...
>***
>* Next crash
>***
>SELECT f1,f2 &lcPattx ;
> FROM myCursor ;
> group by 1, 2 ;
> into cursor myCursor1 ;
> nofilterI seek a way to do by SQL.
>Cetin
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.