>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.
--sb--