General information
Category:
Coding, syntax & commands
Try this:
SELECT ALLTRIM(connombre)+" "+ALLTRIM(conapellidos),;
COUNT(Modelos.modid) as somecount;
FROM ipmsdata!concursantes LEFT OUTER JOIN ipmsdata!modelos ;
ON Concursantes.conid = Modelos.conid;
GROUP BY Modelos.conid;
HAVING somecount > 4
ORDER BY 2 DESC
>Hi all:
>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
>
>If I try to run the form where I have a grid based on this view I get the following error message:
>
>"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?
>TIA for your time.
>Ulises
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only