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 ??