From: "Gerardo Santana Gómez Garrido" <gerardo.santana@...>
Date: 2007-11-24T01:32:25+09:00
Subject: Re: ODBC and Ruby

Hello Lorenzo,

On Nov 23, 2007 7:55 AM, lorenzo <me@me.it> wrote:
> 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

May I suggest you to try the Informix extension instead?

http://ruby-informix.rubyforge.org

-- 
Gerardo Santana