Gilles,
It's documented in VFP8 help under
Behavior Changes Since Visual FoxPro 7.0 and
INFO: SQL SELECT Behavior Changes in Visual FoxPro 8.0 mskb #
813361. One of the way to eliminate this error is to include
Factures.ireservid field into group by clause.
>I have a strange problem in VFP8 with the View Designer :
>
>When I open a view in VFP7 -> no problem, the same view opened in VFP8 give me an error message :
>
>SQL: GROUP BY CLAUSE is missing or invalid.
>
>Here is the SQL syntax of my View :
>
>SELECT Factures.ireservid, Factures.inofac, SUM(Factdetail.iprix);
> FROM ;
> appdata!factures ;
> INNER JOIN appdata!factdetail ;
> ON Factures.inofac = Factdetail.inofac;
> WHERE Factures.lpaye = .F.;
> GROUP BY Factures.inofac;
> ORDER BY Factures.inofac
>Perhaps a solution ??
--sb--