General information
Category:
Coding, syntax & commands
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
Next
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