4 Replies Latest reply: Aug 4, 2010 4:54 PM by sheila.leite RSS

    Progress ODBC Problem

    sheila.leite

      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