Hi Sergey.

The following select sql statement works under VFP6.0. But does not work in VFP8.0 w/ SP1.

SELECT c.h1psyr, c.h1psmo, c.h1psdy, sum(c.h1ramt) as amt, u.u1name ;
FROM userunit u, cscash01 c ;
WHERE u.u1unit = c.h1unit ;
INTO CURSOR ytdcoll ;
ORDER BY 5 ;
GROUP BY 5

All the selected fields are simple character field except the SUM field which is a numberic field.

I lost as to why it's not working in VFP8.0.


>Dean,
>
>Never heard about such problem with grouping on date fields. Is it VFP8? If it's, take a look at help under Behavior Changes Since Visual FoxPro 7.0 and in INFO: SQL SELECT Behavior Changes in Visual FoxPro 8.0 mskb #813361.
>
>
>>I was doing some queries and I noticed that when one of the selected field is a date field, the GROUP BY statement gives an "invalid group by ..." error.
>>