[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&from=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, Slashdot.org! http://sdm.link/slashdot ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
[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&from=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 traditional INI file settings. It also allows to run queries on the connected server. There's minimal error catching and also allows to set the GB.Debug flag to get extra ODBC component debug info on the Gambas Console. I used the attach to connect successfully to MSSQL and Firebird: I was reported an error in the internal RowCount function I implemented in the component when using Firebird and it was successfully patched. The app does not use the graphical data connection nor any data-bound controls. As said, it's very basic but does the job. It also helped me to polish some rough edges on my butchering of the Gambas ODBC component. Hope it helps you also, zxMarce. -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
[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&from=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, Slashdot.org! http://sdm.link/slashdot ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
[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&from=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 the rows cound are provided.. if this not return count, so the method must documented that -.. the count wiki said "Returns the number of records inside the result." so then now noted that returns "-1" now i understand why "-1"... that must be documented in the odbc wiki count page now here the real problem its that if i try to make a select count, and then a select * toa stored procedure, the odbc seems break or lock.. see it here in bug issue #1102 http://gambaswiki.org/bugtracker/edit?object=BUG.1102&from=L21haW4- now i know that i must do as u coded: " While (res.Available)" -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
[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&from=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. -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
[Gambas-user] Possible disturbing bug fix in revision #8132
Hi, Before revision #8132, some custom controls were reacting to mouse events event if disabled, because they didn't take the Enabled property into account. Since revision #8132, disabled controls do not raise mouse events anymore. I did that to fix the previous problem, but it may break some code that was using that "feature". If you are in that case, please tell me. Regards, -- Benoît Minisini -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
[Gambas-user] [Gambas Bug Tracker] Bug #1099: sliderbox sill respond to mouse wheel when its disabled
http://gambaswiki.org/bugtracker/edit?object=BUG.1099&from=L21haW4- Benoît MINISINI changed the state of the bug to: Accepted. -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
[Gambas-user] [Gambas Bug Tracker] Bug #1099: sliderbox sill respond to mouse wheel when its disabled
http://gambaswiki.org/bugtracker/edit?object=BUG.1099&from=L21haW4- Comment #1 by Benoît MINISINI: Fixed in revision #8132. Benoît MINISINI changed the state of the bug to: Fixed. -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
[Gambas-user] [Gambas Bug Tracker] Bug #1097: Date.ToUnixTime loses a day
http://gambaswiki.org/bugtracker/edit?object=BUG.1097&from=L21haW4- Comment #3 by Benoît MINISINI: Can you try revision #8133? -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
[Gambas-user] [Gambas Bug Tracker] Bug #1101: ODBC driver super buggy 2: rs.max return always negative and always -2 event in lasted
http://gambaswiki.org/bugtracker/edit?object=BUG.1101&from=L21haW4- Comment #2 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 in the Unix and mainframe field so please cited a right paper.. not windo/like -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
[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&from=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 in the Unix and mainframe field so please cited a right paper.. not windo/like -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] [Gambas Bug Tracker] Bug #1101: ODBC driver super buggy 2: rs.max return always negative and always -2 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 run queries in C with Easysoft's tutorials... And I absolutely suck at C. That good are those tutorials! Also, in case you didn't know, Microsoft was one of the leading forces behind drafting ODBC, as this quote from Wikipedia says: ODBC was originally developed by Microsoft and Progress DataDirect during the early 1990s, and became the basis for the Call Level Interface (CLI) standardized by SQL Access Group in the Unix and mainframe field. So by using their docs you know that that is the standard. Well, at least theirs... They suck at Windows (and OS making and privacy respecting in general), yes, but they sometimes pull nice tricks off their hats like ODBC. And that is not the only standard they helped draft. But anyway both MS and IBM (at least when I read the docs to make the Gambas component work again) were kind enough to mark clearly any deviations or differences from the standard in their ODBC docs. Hope that helps, zxMarce. On May 3, 2017, 21:19, at 21:19, bugtrac...@gambaswiki.org wrote: >http://gambaswiki.org/bugtracker/edit?object=BUG.1101&from=L21haW4- > >Comment #2 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 in the Unix and >mainframe field so please cited a right paper.. not windo/like -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
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 run queries in C with Easysoft's tutorials... And I absolutely suck at C. That good are those tutorials! Also, in case you didn't know, Microsoft was one of the leading forces behind drafting ODBC, as this quote from Wikipedia says: ODBC was originally developed by Microsoft and Progress DataDirect during the early 1990s, and became the basis for the Call Level Interface (CLI) standardized by SQL Access Group in the Unix and mainframe field. So by using their docs you know that that is the standard. Well, at least theirs... They suck at Windows (and OS making and privacy respecting in general), yes, but they sometimes pull nice tricks off their hats like ODBC. And that is not the only standard they helped draft. But anyway both MS and IBM (at least when I read the docs to make the Gambas component work again) were kind enough to mark clearly any deviations or differences from the standard in their ODBC docs. Hope that helps, zxMarce. On May 3, 2017, 21:20, at 21:20, bugtrac...@gambaswiki.org wrote: >http://gambaswiki.org/bugtracker/edit?object=BUG.1100&from=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 in the Unix and >mainframe field so please cited a right paper.. not windo/like -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] [Gambas Bug Tracker] Bug #1101: ODBC driver super buggy 2: rs.max return always negative and always -2 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, so then m$ its reasonable to are behind that papers) > But anyway both MS and IBM (at least when I read the docs to make the > Gambas component work again) were kind enough to mark clearly any > deviations or differences from the standard in their ODBC docs. > u are the mantainer and author of the ODBC componet? i used extensivelly the ODBC component and i was thinking that i'm the only used deeply.. tomorrow i'll test again a SP that will retrieve a thousands of rows... (currently i make it with a dummy table, production will retrieve thousands) > > Hope that helps, > zxMarce. > > On May 3, 2017, 21:19, at 21:19, bugtrac...@gambaswiki.org wrote: > >http://gambaswiki.org/bugtracker/edit?object=BUG.1101&from=L21haW4- > > > >Comment #2 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 in the Unix and > >mainframe field so please cited a right paper.. not windo/like > > -- > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > ___ > Gambas-user mailing list > Gambas-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/gambas-user > -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
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, so then m$ its reasonable to are behind that papers) > But anyway both MS and IBM (at least when I read the docs to make the > Gambas component work again) were kind enough to mark clearly any > deviations or differences from the standard in their ODBC docs. > u are the mantainer and author of the ODBC componet? i used extensivelly the ODBC component and i was thinking that i'm the only used deeply.. tomorrow i'll test again a SP that will retrieve a thousands of rows... (currently i make it with a dummy table, production will retrieve thousands) Lenz McKAY Gerardo (PICCORO) http://qgqlochekone.blogspot.com 2017-05-03 22:09 GMT-04:00 : > 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 run queries in C with Easysoft's tutorials... > And I absolutely suck at C. That good are those tutorials! > > Also, in case you didn't know, Microsoft was one of the leading forces > behind drafting ODBC, as this quote from Wikipedia says: > > ODBC was originally developed by Microsoft and Progress DataDirect during > the early 1990s, and became the basis for the Call Level Interface (CLI) > standardized by SQL Access Group in the Unix and mainframe field. > > So by using their docs you know that that is the standard. Well, at least > theirs... They suck at Windows (and OS making and privacy respecting in > general), yes, but they sometimes pull nice tricks off their hats like > ODBC. And that is not the only standard they helped draft. > > But anyway both MS and IBM (at least when I read the docs to make the > Gambas component work again) were kind enough to mark clearly any > deviations or differences from the standard in their ODBC docs. > > Hope that helps, > zxMarce. > > On May 3, 2017, 21:20, at 21:20, bugtrac...@gambaswiki.org wrote: > >http://gambaswiki.org/bugtracker/edit?object=BUG.1100&from=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 in the Unix and > >mainframe field so please cited a right paper.. not windo/like > > -- > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > ___ > Gambas-user mailing list > Gambas-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/gambas-user > -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
