topic Progress ODBC Problem in QlikView

Progress ODBC Problem

Wed, 04 Aug 2010 16:27:47 GMT

Hello everyone,

Since yesterday I've been looking trough the Internet something about connections using ODBC Progress, but unfortunately couldn't find anything. So, I'll try to explain you what I'm facing:

I extracted a table where a field is char. This table contais two distinct datas like a code "08" and "8". But after the extraction, the Qlikview is making this two different codes into just one: "8". I've tried to use "char" in the select statement, but I got this message: "SQL Error:[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Inconsistent types (7481) SQL Scriptline:SQL State:S1000"
Here follows my statement:

sch_meta_produc:

SQL

char("cod-meta")

as "cod-meta",

"data-inicio",

"data-termino"

FROM

store

drop

Tks everyone!!!

Sheila

table sch_meta_produc; sch_meta_produc into sch_meta_produc.qvd; PUB."sch-meta-produc" sql where "data-inicio">='01/01/2010'; SELECT

Progress ODBC Problem

suniljain — Wed, 04 Aug 2010 16:55:20 GMT

pls replace text in place of char

Progress ODBC Problem

Wed, 04 Aug 2010 17:20:29 GMT

Sunil, exacltly..............use text() function in place of char().

text() function convert the number data to char.

Progress ODBC Problem

Wed, 04 Aug 2010 17:33:53 GMT

Tks by the suggestion, people, but it still doesn't work. I keep getting the same error message...

Progress ODBC Problem

Wed, 04 Aug 2010 20:54:13 GMT

Hey guys!

I've found a solution. I had to use the CAST command.

sch_meta_produc:

SQL

CAST("cod-meta"

AS char(02)) as "cod-meta",

"data-inicio",

"data-termino"

FROM

store

Tks for your help!

sch_meta_produc into sch_meta_produc.qvd; PUB."sch-meta-produc" sql where "data-inicio">='01/01/2010'; SELECT