SQL Statement doesn't work

[#1]

Hi to All!!!

i have one sql statement but it doesnt work on Qlikview, but it does in SQL:

Transac:

LOAD

IdentifEspacio,

HoraInicio_EC,

HoraFin_EC,

PautaId,

AnoMes,

HoraInicio_OC,

HoraFin_OC,

CantSalidas,

DuracionTot,

VigDesde_CV,

VigHasta_CV,

Frecuencia_CV,

Horario,

Version

;

SQL SELECT EspacioCont.IdentifEspacio, EspacioCont.HoraInicio as HoraInicio_EC, EspacioCont.HoraFin as HoraFin_EC,

OrdenadoCab.PautaId, OrdenadoCab.AnoMes, OrdenadoCab.HoraInicio as HoraInicio_OC, OrdenadoCab.HoraFin as HoraFin_OC, OrdenadoCab.CantSalidas, OrdenadoCab.DuracionTot,

CostoVersion.VigDesde as VigDesde_CV, CostoVersion.VigHasta as VigHasta_CV, CostoVersion.Frecuencia as Frecuencia_CV, CostoVersion.Horario, CostoVersion.Version

FROM

  Publicidad.dbo.EspacioCont ,

  Publicidad.dbo.OrdenadoCab ,

  Publicidad.dbo.CostoVersion

where

  EspacioCont.IdentifEspacio = 'AMER-INTR-PROG' and

  OrdenadoCab.IdentifEspacio = EspacioCont.IdentifEspacio and

  CostoVersion.IdentifEspacio = OrdenadoCab.IdentifEspacio and

  CostoVersion.Version = (select max(CostoVersion.version)

                    from Publicidad.dbo.CostoVersion

                    where CostoVersion.IdentifEspacio = EspacioCont.IdentifEspacio

                    group by CostoVersion.IdentifEspacio)

order by

  EspacioCont.IdentifEspacio;

Why doesnt return me any row???  In Sql the query HAVE 28 rows...

Any Idea?

Thanks to all!

[#2]

Hi Torress,

Instead of renaming in SQL script try to rename in LOAD statement.Remove alias in SQL use drirect fields to load and then rename the fields as per your requirement.

It may solve your problem.

Regards,

Vijay

[Anonymous]

German,

What if your script contains this code but nothing else?  Can you try it?  I expect it to return the same 28 rows.

Check if there is something like INNER JOIN or INNER KEEP, or anything in your script that may affect records in the Transac table.

Regards,

Michael

[#4]

I made this change:

Transac:

LOAD

IdentifEspacio,

HoraInicio as HoraInicio_EC,

HoraFin as HoraFin_EC,

PautaId,

AnoMes,

HoraInicio as HoraInicio_OC,

HoraFin as HoraFin_OC,

CantSalidas,

DuracionTot,

VigDesde as VigDesde_CV,

VigHasta as VigHasta_CV,

Frecuencia as Frecuencia_CV,

Horario,

Version

;

SQL SELECT EspacioCont.IdentifEspacio, EspacioCont.HoraInicio, EspacioCont.HoraFin,

OrdenadoCab.PautaId, OrdenadoCab.AnoMes, OrdenadoCab.HoraInicio, OrdenadoCab.HoraFin, OrdenadoCab.CantSalidas, OrdenadoCab.DuracionTot,

CostoVersion.VigDesde, CostoVersion.VigHasta, CostoVersion.Frecuencia, CostoVersion.Horario, CostoVersion.Version

FROM

  Publicidad.dbo.EspacioCont ,

  Publicidad.dbo.OrdenadoCab ,

  Publicidad.dbo.CostoVersion

where

  EspacioCont.IdentifEspacio = 'AMER-INTR-PROG' and

  OrdenadoCab.IdentifEspacio = EspacioCont.IdentifEspacio and

  CostoVersion.IdentifEspacio = OrdenadoCab.IdentifEspacio and

  CostoVersion.Version = (select max(CostoVersion.version)

                    from Publicidad.dbo.CostoVersion

                    where CostoVersion.IdentifEspacio = EspacioCont.IdentifEspacio

                    group by CostoVersion.IdentifEspacio)

order by

  EspacioCont.IdentifEspacio;

And it doesnt solve the problem...

Thanks anyway Vijay

[#5]

Michael

Im trying with this instruction only... nothing else.

And if i bring only one table, it does return me results.

But when i add other table in the same query...  no results...

[Anonymous]

Not clear, sorry...

Is there any difference if you use only this (and nothing else in whole script):

LOAD

...

SQL SELECT

...

;

And if you use only this (and nothing else in whole script):

SQL SELECT

...

;

[#7]

i tryied and rerutns mi ODBC Error... 

[Anonymous]

What exactly the error is?

Is it for SQL SELECT without LOAD?

[#9]

The message say: Fail reading ODBC

[Anonymous]

Hmm...  Can't help with this...  I assume you haven't changed the  CONNECT statement.

ODBCs sometimes not reliable.  I recommend OLEDB instead, if possible.