The changes occured in VFP8. See Re: Change in SQL commands! Message #941774 for details.

>
>It seems like the Group By clause has been changed in version 9.0
>
>Till now I was used to
>
>

Select * from <table name> group by <field name>

>
>It is giving error in ver 9. Any help on that ?
>
>