From: lorenzo <me@...>
Date: 2007-11-23T22:55:05+09:00
Subject: ODBC and Ruby

hello, I'm new in ruby, I've problems conneting ruby odbc with informix 
db, in tbles with thousand records my program always retruns no rows,

this is the test program:

sth=c.prepare("select * from anopta")

sth.execute
if sth.ncols == 0 then
     puts "Statement has no result set"
     printf "Number of rows affected: %d\n", sth.nrows
   else
     puts "Statement has a result set"
     sth.fetch_all
     printf "Number of rows: %d\n", sth.nrows
     printf "Number of columns: %d\n", sth.ncols
  end


this is the output

Statement has a result set
Number of rows: -1
Number of columns: 5

The table has 5 colums and 300 rows

I don't know if this problem is specific for informix databases

thank u very much