>I recently upgrade to VFP9 and sudenly some of my selects stop working as they were in VFP7. But only those which I have used group by clause. I can not get it to work. Did the sintaxe changed? I even tried the wizard to create it but got the same error.
>SQL: group by clause is missing or invalid.
>Anyone got this problem, too?
See the help for SET ENGINEBEHAVIOR.
Short-term solution: Make your queries backwards-compatible with this command.
Long-term solution: Adapt your queries to the new syntax, which is stricter and safer.
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)