Check in the help under What's New......Changes in Functionality for the Current Release
This is by design to fix a weak SQL implementation to be more compatible with others. Short term fix of SET DATAENGINE 70 will help you get started, but you should start working towards the new syntax.
Bob
>I’m getting:
>
>SQL: Group By clause is missing or invalid
>
>when I try opening views which were OK in VFP7.0 .
>
>
>
>Can anyone shed any light on the subject?
'If the people lead, the leaders will follow'
'War does not determine who is RIGHT, just who is LEFT'