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