>>>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.
Why do you think that everything MS does is about you. :)
I pointed to this problem with queries many times. Here're a few examples:
-
Re: Insonsistent Data Returned Message #
558004-
Re: Select Max(field1) + its corresponding fields? Message #
571657-
Re: Problem with MAX() in SELECT Message #
609503-
Re: SELECT SQL and MAX() Message #
609504-
Re: Problem in writing SQL(detail) Message #
681074So it wasn't imaginable problem as you think.
--sb--