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