Microsoft Visual Foxpro:VFP.EXE - Application Error
The instruction at "0x77fc9ba0" referenced memory at "0x00000134". The memory could not be "written".
Click on OK to terminate the program
Click on CANCEL to debug the program
I'm afraid I disagree it's a pure & problem. _cliptext method is used to remove & and type sum()... It also bombs.
Anyway thanks.
Cetin
>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