Luigi,
Check Behavior Changes Since Visual FoxPro 7.0 -> SQL Data Engine in Help and take a look in SET ENGINBEHAVIOUR command

SET ENGINBEHAVIOUR 70
SELECT Loglav.clavcod, Loglav.ccolcod, Loglav.cpiacod, Loglav.cparcod;
 FROM loglav;
 GROUP BY Loglav.clavcod
* or
SELECT Loglav.clavcod, Loglav.ccolcod, Loglav.cpiacod, Loglav.cparcod;
 FROM loglav;
 GROUP BY Loglav.clavcod, Loglav.ccolcod, Loglav.cpiacod, Loglav.cparcod

>Hi
>
>I am porting my applications in VFP8 from VFP6, there is somethig strange in SQL syntax using Group By that seem does not work also usin Query designer here is an simple example
>
>

>SELECT Loglav.clavcod, Loglav.ccolcod, Loglav.cpiacod, Loglav.cparcod;
> FROM loglav;
> GROUP BY Loglav.clavcod
>

>
>This code generate an error "SQL Group By Clause is missing or invalid"
>
>Any idea how to solve ?
>
>Thank you
>Luigi