[Gambas-user] [Gambas Bug Tracker] Bug #1013: gb.db.odbc new GetRecordCount mechanism seem not work with firebird database

2016-11-11 Thread bugtracker
http://gambaswiki.org/bugtracker/edit?object=BUG.1013=L21haW4- Comment #16 by Christian FAURE: Thanks! new version of GetRecordCount() work fine with Firebird database!!! --- gb.db.odbc: 0xea8148: select current_date as MyDate from RDB$DATABASE gb.db.odbc.GetRecordCount: First recno=0

Re: [Gambas-user] Gambas2 Grab in Gambas3

2016-11-11 Thread Richard Welch
Fabien, right on the button. Cached now seems to work for me - when the code was first written in G2 some years ago, minimising the window blanked the DrawingArea to background and overlaying it with a window from another application blanked the hidden part of the DrawingArea (I can't now

[Gambas-user] [Gambas Bug Tracker] Bug #1013: gb.db.odbc new GetRecordCount mechanism seem not work with firebird database

2016-11-11 Thread bugtracker
http://gambaswiki.org/bugtracker/edit?object=BUG.1013=L21haW4- Comment #15 by Benoît MINISINI: The open_database() driver function takes a DB_DESC structure pointer as first argument. Modify the name in that structure that way: GB.FreeString(POINTER(>name)); desc->name =

[Gambas-user] [Gambas Bug Tracker] Bug #1013: gb.db.odbc new GetRecordCount mechanism seem not work with firebird database

2016-11-11 Thread bugtracker
http://gambaswiki.org/bugtracker/edit?object=BUG.1013=L21haW4- Comment #14 by zxMarce: Benoît, Actually, it was not that hard. The subtraction trick did its job flawlessly (and fast, even with the additional API calls), and the function even worked as expected when faced a row-less query. In

[Gambas-user] [Gambas Bug Tracker] Bug #1013: gb.db.odbc new GetRecordCount mechanism seem not work with firebird database

2016-11-11 Thread bugtracker
http://gambaswiki.org/bugtracker/edit?object=BUG.1013=L21haW4- Comment #13 by Benoît MINISINI: Just a remark: if it is too hard to make a generic GetRecordCount() method, you can store in your database connection object the underlying ODBC connection type so that you can use a different method

[Gambas-user] [Gambas Bug Tracker] Bug #1013: gb.db.odbc new GetRecordCount mechanism seem not work with firebird database

2016-11-11 Thread bugtracker
erRecIdx = 0; //Where we were when this all started. SQLINTEGER myRecCnt = -1; //Default for when there's no cursor. SQLINTEGER firstRecNo = 0; //2016 holder for 1st recno. SQLINTEGER lastRecNo = 0; //2016 holder for last recno. c