0 Replies Latest reply: Jul 27, 2012 10:14 AM by 952226 RSS

    Oracle ODBC driver recognizes integer columns as Double

    952226
      When I execute my SQL statement (shown below) using Oracle ODBC driver, all integer columns are retrieved from the derived table as Double into .Net!!!
      When I use OleDB driver the integer columns are returned as integers.

      Select
      f.lot_key,i2 wf_key,f.start_time,i0,i1,i3,i4,d.t1,d.t2
      From
      RES67 d,
      +(Select lg.lg_key,lg.lot_key,lg.src_lot,wl.wf_key,lg.start_time From op_log lg ,wf_log wl+
      Where lg.lg_key=wl.lg_key And  lg.pg_key=67  And lg.lot_key in (31)) f
      Where
      d.lg_key=f.lg_key And d.i3=f.wf_key;

      Where all _key columns are defined in DB as Integer fields.

      If I use temporary table instead of the derived table, then ODBC returns integer columns!!!!

      I use the following connection string:
      dsn=myDsn;database=myDB;uid=x;pwd=x

      Please advise.