Information générale
Catégorie:
Codage, syntaxe et commandes
I don't know about view builder, but WHERE should be replaced by HAVING.
You can't use aggregate functions in WHERE clouse.
>I built a view with the view builder. The SQL looks like this:
>
>SELECT ALLTRIM(connombre)+" "+ALLTRIM(conapellidos),;
> COUNT(Modelos.modid);
> FROM ipmsdata!concursantes LEFT OUTER JOIN ipmsdata!modelos ;
> ON Concursantes.conid = Modelos.conid;
> WHERE count(Modelos.modid) > 4;
> GROUP BY Modelos.conid;
> ORDER BY 2 DESC
>
>"Error loading file-record number 7.Form1 . Loading form or the data environment: File 'count.prg' does not exist"
>
>If I remove the filter (the WHERE clause) the form loads correctly, but I don't have the information as I need it. What causes that an expression being evaluated or considered as a .prg file? That expression is built with the expression builder, so it should be ok... or not?
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement