[Gambas-user] [Gambas Bug Tracker] Bug #1100: ODBC driver super buggy 1: rs.count return always negative and only one event in lasted

[bugtracker at ...3416...]

http://gambaswiki.org/bugtracker/edit?object=BUG.1100&from=L21haW4-

Comment #10 by PICCORO LENZ MCKAY:

due the result object to make the MoveTo need the count for...  as said zxMarce all .MoveXXX methods except .MoveNext SEEMS need a record count from the provider. so there's no way for the DAta event to fill the grid using ODBC and sybase...

1) this kind of information MUST BE in the documentation Benoit
2) the odbc standard does not have that unless a INSERT, UPDATE or DELETE was done

Now lest try with the second suggestion .. ODBC does not permit subquerys if a recorset are still open.. 

all the code will must go to the odbc gambas implementation due by example if i do:

select count(codigo) as cuanto from dba.ta_sys_existencias_dinamicas order by cuanto limit 50000 offset 0

and in other result i do

select * from dba.ta_sys_existencias_dinamicas order by col1 limit 50000 offset 0

take in consideration the limit indicate only 50000 rows, the odbc does not report the amount , but due strange reasons, the where( rs.available) will iterate over the 50000 rows event the count select only return one row!

as i said:

a) for close this bug the documentation must be updated with methods to fill a grid from odbc
b) the respective non_working events and methods must be update in documentation
c) there's only 4 modules for DB access, all have good working excepts odbc?

seem quite complicated to explain and its not documented in any place in wiki..