Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View Designer
Message
From
10/04/2003 08:55:13
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
View Designer
Miscellaneous
Thread ID:
00775977
Message ID:
00775977
Views:
42
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 ??
Gilles Azria
-------------------------------------------------
http://www.profiledatabase.com
http://www.photoprofile.ch
Next
Reply
Map
View

Click here to load this message in the networking platform