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?