ODBC and Ruby

[lorenzo]

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

 

[Gerardo Santana Gómez Garrido]

Hello Lorenzo,

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

 

[lorenzo]

On 2007-11-23 17:32:25 +0100, Gerardo Santana Gómez Garrido
<[email protected]> said:
Hello,
Is not so easy, I'm using Macosx and I don' have informix sdk for it
Have you any ideas?
Thank you

 

[Gerardo Santana Gómez Garrido]

On 2007-11-23 17:32:25 +0100, Gerardo Santana G=F3mez Garrido
<[email protected]> said:
Hello,
Is not so easy, I'm using Macosx and I don' have informix sdk for it

I see.

Have you any ideas?
Thank you

Yes. I have just remembered (I used to use ruby-odbc with Informix two
years ago) that nrows didn't return any useful value to me for
Informix. Ignore it. You can't know how many records a SELECT returns
in Informix before fetching them.

--=20
Gerardo Santana