Question about direct query

[Anonymous]

Hi,

I am trying to use direct select in Qlikview Personal Edition 12.1

I have this query in scripts editor and it works fine:

ODBC CONNECT32 TO [odbc_consumo;DBQ=C:\.........\ficheros\modelo_estrella.mdb];

SQL SELECT cod_cliente,cod_periodo,cod_segmento,cod_tarifa,cod_terminal,hc_consumo

FROM hc_consumo;

Now I am trying to use in direct mode:

ODBC CONNECT32 TO [odbc_consumo;DBQ=C:\.........\ficheros\modelo_estrella.mdb];

DIRECT SELECT cod_cliente,cod_periodo,cod_segmento,cod_tarifa,cod_terminal,hc_consumo

FROM hc_consumo;

But it doesn' work.....teh error is

"No Direct statement

DIRECT SELECT cod_cliente,cod_periodo,cod_segmento,cod_tarifa,cod_terminal,hc_consumo

FROM hc_consumo"

Can anybody help me?

[Anonymous]

Hi Miguel Angel,

Now it's working better, but not fine...

For example:

If I update database filed hc_consumo=value1 in a row of cod_periodo = 201706 and I make a selection in Qlikview in the chart for cod_periodo = 201706 then I see the new value, but when I return to the whole chart (no selection)

I see the old value (value0)

I make other change in hc_consumo=value2 in the same cod_periodo = 201706

then it doesn't change even if i make a selection I see the value of the first change (value1), and in the whole chart the old value (value0)

Is this the normal way of working of direct query??

Thanks

[Anonymous]

Thanks for your help Miguel Angel.

This was the problem

[hugmarcel]

Good Question. Did you ever get an answer to this?

[Anonymous]

Yes, it was a question of cache as it was answered in previous posts