topic Problème urgent SQL in QlikView

Problème urgent SQL

Tue, 17 Aug 2010 09:21:10 GMT

Bonjour la communauté

Je suis vraiment tres bizarre ces derniers jours. J'ecris mes requetes, elles fonctionnent bien sous TOD FOR ORACLE. Mais quand je les importe dans Qlikview, c'est la vrai ***. Ca ne marche jamais.

Exemple:

SELECT c.nomredclass libpere, c1.nomredclass libfils1,
c2.nomredclass libfils2, SUM (e.cpt_mtdb)
FROM comclass c

LEFT JOIN comclass c1
ON c1.cdos = c.cdos AND c1.numpere = c.codclass

LEFT JOIN comclass c2
ON c2.cdos = c1.cdos AND c2.numpere = c1.codclass

LEFT JOIN deltaerp.comecrgen e
ON e.cdos = c2.cdos AND SUBSTR (e.numcpt, 0, 3) = c2.codclass /* filtre sur les dates : */

LEFT JOIN deltaerp.comdos d
ON d.cdos = c2.cdos AND d.nred = 'BGFI' AND e.datcpt between d.ddex and d.dfex

WHERE c.cdos = '01'
AND c.numpere = 'MAIN'
AND c.ctab = '20105'
AND c.codclass = '2'
GROUP BY c.nomredclass,
c1.nomredclass,
c2.nomredclass
ORDER BY c.nomredclass,
c1.nomredclass,
c2.nomredclass

Cette requete me donne le bon resultat sous TOAD mais sous Qlikview, elle me retourne des erreurs du genre: Voivi l'erreur:

Champ non trouvé - <Classe>
SQL SELECT c.nomredclass as Classe, c1.nomredclass as Sous_Classe1,
c2.nomredclass as Sous_Classe2, SUM (e.cpt_mtdb) as mount
FROM comclass c

LEFT JOIN comclass c1
ON c1.cdos = c.cdos AND c1.numpere = c.codclass

LEFT JOIN comclass c2
ON c2.cdos = c1.cdos AND c2.numpere = c1.codclass

LEFT JOIN deltaerp.comecrgen e
ON e.cdos = c2.cdos AND SUBSTR (e.numcpt, 0, 3) = c2.codclass

LEFT JOIN deltaerp.comdos d
ON d.cdos = c2.cdos AND d.nred = 'BGFI' AND e.datcpt between d.ddex and d.dfex

WHERE c.cdos = '01'
AND c.numpere = 'MAIN'
AND c.ctab = '20105'
AND c.codclass = '2'
GROUP BY c.nomredclass,
c1.nomredclass,
c2.nomredclass
ORDER BY c.nomredclass,
c1.nomredclass,
c2.nomredclass

Merci pour votre réaction

Problème urgent SQL

Tue, 17 Aug 2010 10:10:38 GMT

Hi,

Can you please post in English?

-Haneesh

Re. :Re: Problème urgent SQL

Tue, 17 Aug 2010 10:28:31 GMT

Hello community

I am really very strange in recent days. I write my applications, they work well under DOT FOR ORACLE. But when I import them into Qlikview is the true difficulty. It never works.

This query gives me good result in TOAD but under Qlikview, she returns errors like: voive the error:

Re. :Re: Problème urgent SQL

llauses243 — Tue, 17 Aug 2010 10:44:38 GMT

Pls to look ...

Re. :Re: Re. :Re: Problème urgent SQL

Tue, 17 Aug 2010 11:34:34 GMT

The error message is the same. Always

Field not found - <Classe>

Thnks