>The problem as I see it is the legacy code. There may be hundreds of programs that presently run correctly but either might not run or would return incorrect results because of changes in the SQL engine. Do you know what conditions changed in the SQL Engine or where I can find that nformation? I want to migrate code to VFP8 (and 9 later this year), but this issue would halt that dead in its tracks.
>

As I understand it, the changes fall into two categories. First, some bugs were fixed, but no doubt some people have code that relied on the buggy behavior.

Second, changes were made to deal with cases where you might get correct results, but might not because of ambiguity. That's the case with the GROUP BY changes.

The only suggestion I can make is to wrap the problem queries in SET ENGINEBEHAVIOR 70 until you have time to go through them one by one and clean them up.

Tamar