http://gambaswiki.org/bugtracker/edit?object=BUG.1013&from=L21haW4-
Comment #17 by zxMarce:
Christian,
Thanks for your feedback.
I'll try to add the further patch for retrieving the database name to gb.odbc
and send the updated component sources to Benoît for publishing.
Regards,
zxMarce.
zxM
http://gambaswiki.org/bugtracker/edit?object=BUG.1013&from=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
http://gambaswiki.org/bugtracker/edit?object=BUG.1013&from=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(&desc->name));
desc->name = GB.NewZeroS
http://gambaswiki.org/bugtracker/edit?object=BUG.1013&from=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.
http://gambaswiki.org/bugtracker/edit?object=BUG.1013&from=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 met
http://gambaswiki.org/bugtracker/edit?object=BUG.1013&from=L21haW4-
Comment #12 by zxMarce:
Christian,
Well, it looks like my guess was correct. I patched the function so it now does
as follows:
1- Remember the current RowIndex
2- Fetch the index of the first record (firstIndex)
3- Fetch
http://gambaswiki.org/bugtracker/edit?object=BUG.1013&from=L21haW4-
Comment #11 by Christian FAURE:
Well, thanks zxMarce for the information, very appreciated work.
Best regards.
--
Developer Access Program for Intel
http://gambaswiki.org/bugtracker/edit?object=BUG.1013&from=L21haW4-
Comment #10 by zxMarce:
Christian,
Finally! I installed FB2.5, the ODBC driver, and even got a simple test DB with
an eight record table, hand populated with ye olde ZX-Spectrum colors (fields
ColorName and ColorValue).
Also c
http://gambaswiki.org/bugtracker/edit?object=BUG.1013&from=L21haW4-
Comment #9 by Christian FAURE:
Thanks for your time, the response time is not critical for me.
My current setup is Firebird 2.5.6 (Classic) with libOdbcFb.so 2.0.2,
i've seen an libOdbcFb.so version 2.0.4 available on firebird si
http://gambaswiki.org/bugtracker/edit?object=BUG.1013&from=L21haW4-
Comment #8 by zxMarce:
Christian,
Sorry for the time it takes for me to answer.
Well, the example code is correct (and I have seen it before), but if you
follow the SQLRowCount() link in the explanatory text you get to the cal
http://gambaswiki.org/bugtracker/edit?object=BUG.1013&from=L21haW4-
Comment #7 by Christian FAURE:
after reading a bit of documentation,
as you say, the SQLRowCount is for updates/inserts/deletes not for Selects,
but at unixodbc site they indicates to use SQLRowCount for selects:
http://www.unixo
http://gambaswiki.org/bugtracker/edit?object=BUG.1013&from=L21haW4-
Comment #6 by Christian FAURE:
Thanks for explain the SQLRowCount,
i've tested with column name, but result is the same:
---
gb.db.odbc: 0xe40a48: select current_date as MyDate from RDB$DATABASE
gb.db.odbc.GetRecordCount:
http://gambaswiki.org/bugtracker/edit?object=BUG.1013&from=L21haW4-
Comment #5 by zxMarce:
I will create a FB DB in my machine and will test this.
Normally, as per the documentation, ODBC's SQLRowCount() only return a valid
row count for INSERT and DELETE statements.
But Gambas does need a 'pro
http://gambaswiki.org/bugtracker/edit?object=BUG.1013&from=L21haW4-
Comment #4 by Christian FAURE:
If you want, i can run a firebird database instance at home and provide the ip
address, port and login (via private mail) to test/debug
let me know.
-
http://gambaswiki.org/bugtracker/edit?object=BUG.1013&from=L21haW4-
Comment #3 by Christian FAURE:
Thanks for review this problem,
this is the test code:
Print "---"
FBConnect() ' connect to database
Db.Debug = True ' enable debug messages
Try rs = fb.Exec("select current_date fr
http://gambaswiki.org/bugtracker/edit?object=BUG.1013&from=L21haW4-
Comment #2 by Benoît MINISINI:
From zxMarce:
Christian,
Hi. I made the GetRecordCount() function.
Can you please be more specific as why it does not work for you? I do not have
an FB DB to test, so if you could please be clea
Le 25/09/2016 à 23:14, d4t4f...@gmail.com a écrit :
> Christian,
>
> Hi. I made the GetRecordCount() function.
>
> Can you please be more specific as why it does not work for you? I do not
> have an FB DB to test, so if you could please be clear as how it fails I'll
> appreciate it.
>
> Thank you
http://gambaswiki.org/bugtracker/edit?object=BUG.1013&from=L21haW4-
Comment #1 by PICCORO LENZ MCKAY:
seems not work for many, in sybase, always get the numbre but negative!
and with others always retuns zero or negative depending of the query
--
http://gambaswiki.org/bugtracker/edit?object=BUG.1013&from=L21haW4-
PICCORO LENZ MCKAY changed the state of the bug to: Opened.
--
___
Gambas-user mailing list
Gambas-user@li
http://gambaswiki.org/bugtracker/edit?object=BUG.1013&from=L21haW4-
zxMarce changed the state of the bug to: NeedsInfo.
--
___
Gambas-user mailing list
Gambas-user@lists.sour
Christian,
Hi. I made the GetRecordCount() function.
Can you please be more specific as why it does not work for you? I do not have
an FB DB to test, so if you could please be clear as how it fails I'll
appreciate it.
Thank you,
zxMarce.
On Sep 25, 2016, 17:42, at 17:42, bugtrac...@gambaswi
http://gambaswiki.org/bugtracker/edit?object=BUG.1013&from=L21haW4-
Christian FAURE reported a new bug.
Summary
---
gb.db.odbc new GetRecordCount mechanism seem not work with firebird database
Type : Bug
Priority : Medium
Gambas version : Unknown
Product : Unk
22 matches
Mail list logo