Progress ODBC Problem

[#1]

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

[suniljain]

pls replace text in place of char

[#3]

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

text() function convert the number data to char.

[#4]

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

[#5]

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