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
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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.