Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
A view problem.
Message
From
15/06/2001 05:20:45
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
A view problem.
Miscellaneous
Thread ID:
00519851
Message ID:
00519851
Views:
56
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
Map
View

Click here to load this message in the networking platform