Jim,

You still missing the point. They fixed bugs in SQL Engine, nothing more. The ANSI compability was a result or the way of bug fixes not an addition to the bug fixes. As Gene mentioned in Re: GROUP BY 1 no longer works Message #754560, the discussion was about what make a default, VFP7 or VFP8 SQL Engine behavior.

>Sergey,
>
>It was YOU who said "VFP8 implementation is consistent with ANSI standard.", not me!
>I then explained that they could have retained the ANSI compatability AND the fixes with a different implementation that didn't 'break' existing code and that would have been my preference. But, as I said to Tamar, we get what we get.
>To be clearer: They could have fixed the bugs and left all else alone. They didn't, opting instead to add conformance to ANSI as well. I feel that they could have chosen to provide an ANSI compatibility WARNING in SYS(3054) output and let BOTH ANSI and old (non-ANSI) syntax work.
>Tamar has explained that various options were discussed and that the chosen methond has its benefits. While I disagree, I do accept that.
>But hopefully this discussion will cause additional reflection the next time that a similar choice is called for.