odbc read failed

matfurrier — Mon, 05 May 2014 12:38:45 GMT

My friends,

when creating the script below, an error is displayed on the screen, accusing odbc error in reading.

Can anyone help me?

Hugs.

HOMOLOGREPORT:
LOAD
DATA AS [Data],
CONSULTOR AS [Consultor],
CLIENTE AS [Código do Cliente],
NOME_CLI AS [Nome do Cliente],
PROD_HOM AS [Produto Homologado],
PROD_ESTR1 AS [Produto Estratégico],
PROD_ESTR2 AS [Produto Estratégico],
PROD_ESTR3 AS [Produto Estratégico],
PROXIMO_PASSO AS [Próximo Passo],
STATUS_VISITA AS [Status da Visita],
RESPONSAVEL AS [Responsável],
DESCRICAO AS [Descrição];


SELECT 
DATA,
CONSULTOR,
CLIENTE,
NOME_CLI,
PROD_HOM,
PROD_ESTR1,
PROD_ESTR2,
PROD_ESTR3,
PROXIMO_PASSO,
STATUS_VISITA,
RESPONSAVEL,
DESCRICAO
FROM HOMOLOGREPORT;


STORE HOMOLOGREPORT INTO ;
DROP TABLE HOMOLOGREPORT;

Re: odbc read failed

alexandros17 — Mon, 05 May 2014 12:41:51 GMT

The problem is that you cannot have 3 fields with the same name in the same table

PROD_ESTR1 AS [Produto Estratégico],
PROD_ESTR2 AS [Produto Estratégico],
PROD_ESTR3 AS [Produto Estratégico],

Re: odbc read failed

matfurrier — Mon, 05 May 2014 13:02:14 GMT

Perfect !

Hugs.

topic odbc read failed in QlikView

odbc read failed

Re: odbc read failed

Re: odbc read failed