>We are jumping from VFP 7 to 9. In running our appl to check for anomolies we are seeing issues with queries. Specifically GRoup By clauses.
>
>I thought I read somewhere that the Group By syntax changed from 7-8 to be morew T-SQL like to where all your columns except aggregates in the query must be in the Group By clause unlike before where you only put in specific colmns. Van someone briefly enlighten me?
You can maintain compatibility with old code, by changing SET ENGINEBEHAVIOUR. Consider this a temporary measure.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)