Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
IIF SUM() within a SUM
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
IIF SUM() within a SUM
Divers
Thread ID:
00874258
Message ID:
00874258
Vues:
49
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform