It's documented in VFP8 help under Behavior Changes Since Visual FoxPro 7.0 and in INFO: SQL SELECT Behavior Changes in Visual FoxPro 8.0 mskb #813361.


>Hi,
>
>i' have a problem in this command:
>
>Select cd_rua,ALLTRIM(n_porta)+" - " + fraccao as andar,idutente,idproc,nr_proc,ano_obra,Str(processos.ano_obra,4)+Str(processos.nr_proc,10) As _n_obra From processos Where processos.cd_rua = ruas.idrua GROUP BY andar Order By andar Desc Into Cursor _jj2
>
>the error say:
>
>SQL: GROUP BY clause is missing or invalid.
>
>i' use VFP 8.0
>
>when i use VFP 7.0 the sintax is ok.
>
>Thank you all
>
>J. Godinho