>>>The new GROUP BY requirements (an attempt to make VFP SQL more similar to MS SQL Server) really creates problems without the related MS SQL commands like WITH ROLLUP and WITH CUBE. I sure hope these functions are added in the next VFP... or maybe that VFP's ideas about GROUP BY are rolled into SQL Server (fat chance, eh)?
>>
>>Michael,
>>
>>The changes to SQL engine in VFP8 was made because some queries (DISTINCT with memo and GROUP BY with fields not included in the GROUP BY) could return incorrect results in previous versions of VFP. It also make VFP queries more ANSI compatible and similar to other backends.
>
>I had no problems with GROUP BY before because I used statements like MAX() or LAST() or ORDER BY to define which field records I wanted to see. Thanks to MS for solving problems I didn't have while creating new ones we can't seem to circumvent without reverting to the previous behaviour.
Well, Max() will still work fine, right?
I know that this is just one detail of your overall point, but I want to make sure that I understand you correctly.
The whole problem with the world is that fools and fanatics are always so certain of themselves, but wiser people so full of doubts. - Bertrand Russell