Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
View Designer
Message
De
10/04/2003 09:08:37
 
 
À
10/04/2003 08:55:13
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Divers
Thread ID:
00775977
Message ID:
00775989
Vues:
15
I don't know why but the problem seems to be with the column SUM(Factdetail.iprix) !!!

Strange...

>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform