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

http://gambaswiki.org/bugtracker/edit?object=BUG.1100=L21haW4- Comment #13 by PICCORO LENZ MCKAY: now this its a confirmed bug: seems the odbc implementation for TDS protocol in gambas does not enabled the advanced cursor.. and uses the default cursor, that does not support subquerys (multiple

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

http://gambaswiki.org/bugtracker/edit?object=BUG.1100=L21haW4- Comment #12 by Leonardo SALAZAR: I reproduce the error in debian 7 gambas 3.4.2 the next piece of code always return "-1" Try rs = $conexionodbc.Exec(query) If rs.Available Then ' howmany = rsprices.Count '

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

http://gambaswiki.org/bugtracker/edit?object=BUG.1100=L21haW4- Comment #11 by PICCORO LENZ MCKAY: hello i tested all the available knowed odbc modules with gambas code, and rs.count only returns a result.count with mysql! again, seems here there are some spected racism.. Quote: SQLRowCount

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

http://gambaswiki.org/bugtracker/edit?object=BUG.1100=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

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

http://gambaswiki.org/bugtracker/edit?object=BUG.1100=L21haW4- Comment #9 by PICCORO LENZ MCKAY: for close this bug, we need > * or update the gambas wiki documentation (please all languajes) * or provide better handle of the rs.count that perdon me, its very confuse provide such method and no

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

2017-05-03 22:04 GMT-04:00 : > Also, in case you didn't know, Microsoft was one of the leading forces > behind drafting yeah.. i use sybase the original software behind the SQL server and the only way to connect to its odbc (inclusivelly internally always used odbc bridgeds,

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

Hehe... you're right. But I also cited IBM's ODBC docs for its DB2, and you can also check Easysoft's excellent C tutorials at http://www.easysoft.com/developer/languages/c/odbc_tutorial.html. Speaking about Easysoft, I myself made a command line ODBC tool to connect with ConnectionStrings and

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

http://gambaswiki.org/bugtracker/edit?object=BUG.1100=L21haW4- Comment #8 by PICCORO LENZ MCKAY: i noyed u only cited mocosoft papers.. dont know about mocosoft like papers.. mocosoft tendts to change everything depends of their convenience... odbc its today standardized by SQL Access Group

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

http://gambaswiki.org/bugtracker/edit?object=BUG.1100=L21haW4- Comment #7 by PICCORO LENZ MCKAY: marked as working due ODBC specifications said there's no mechanish for count... but needs update documentation wiki! PICCORO LENZ MCKAY changed the state of the bug to: Opened.

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

http://gambaswiki.org/bugtracker/edit?object=BUG.1100=L21haW4- Comment #6 by PICCORO LENZ MCKAY: ZXMARGE thanks for the tip, i'm aware of the new features related to connection in recent odbc.. but i not thanking about.. in any case, i posted as a bug due in others languajes like php and java

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

http://gambaswiki.org/bugtracker/edit?object=BUG.1100=L21haW4- PICCORO LENZ MCKAY changed the state of the bug to: Working. -- Check out the vibrant tech community on one of the world's most engaging tech sites,

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

http://gambaswiki.org/bugtracker/edit?object=BUG.1100=L21haW4- Comment #5 by zxMarce: Piccoro, Just added an attach with a pretty much generic ODBC component test project. It allows to connect with the new ConnectionString approach (can connect without putting server info in INI files), or the

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

http://gambaswiki.org/bugtracker/edit?object=BUG.1100=L21haW4- zxMarce added an attachment: ODBCTester Public.tar.gz -- Check out the vibrant tech community on one of the world's most engaging tech sites,

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

http://gambaswiki.org/bugtracker/edit?object=BUG.1100=L21haW4- Comment #4 by zxMarce: Actually, per practically any available documentation you can check, ODBC doesn't return a row count for SELECT statements. I'll refer you to MSDN, for example

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

http://gambaswiki.org/bugtracker/edit?object=BUG.1100=L21haW4- Comment #3 by PICCORO LENZ MCKAY: preparing a project for that its quite tedius, and its obviusly.. i notes that only the "mysql" module are well knowed.. the rest have some bugs always.. i reported some time ago piece of

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

http://gambaswiki.org/bugtracker/edit?object=BUG.1100=L21haW4- Comment #2 by Tobias BOEGE: >If rs.Available Then ' <--- Here we have -1 !!! Result.Available is a Boolean. It is expected that its numerical value is -1 (meaning True). >howmany = rsprices.Count ' < psst ¡always get here -1!

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

http://gambaswiki.org/bugtracker/edit?object=BUG.1100=L21haW4- Comment #1 by PICCORO LENZ MCKAY: NOTE: using a freetds odbc bridge with sybase.. in php retrieve correct roms and in java so i dischard NOTE2: same with postgres but using odbc

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

http://gambaswiki.org/bugtracker/edit?object=BUG.1100=L21haW4- PICCORO LENZ MCKAY reported a new bug. Summary --- ODBC driver super buggy 1: rs.count return always negative and only one event in lasted Type : Bug Priority : High Gambas version : 3.9 Product