>>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.
Kogo Michael Hogan
"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?
Ideate Web Site