Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
IIF SUM() within a SUM
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
IIF SUM() within a SUM
Miscellaneous
Thread ID:
00874258
Message ID:
00874258
Views:
48
I am trying to figure out what is wrong with this query
SELECT 	CurData.cdeptno as NoDpto, ;
	sum(IIF(CurData.Pais='LOC',sum(CurData.dias) / count(CurData.articulo),0000000.00)) as PLocal, ;
	sum(IIF(CurData.Pais='INT',sum(CurData.dias) / count(CurData.articulo),0000000.00)) as PInter ;
	FROM CurData ;
	INTO CURSOR CurLocal ;
	GROUP BY CurData.cdeptno
it gives me a sum.prg does not exist, why?
.......
DO WHILE .T.
      ME.Work()
ENDDO
Next
Reply
Map
View

Click here to load this message in the networking platform