[Gambas-user] ODBC - unable to fetch row

[PICCORO McKAY Lenz]

HEy kicking177 check #1100
http://gambaswiki.org/bugtracker/edit?object=BUG.1100

odbc cannot count on resultset.. is not part of the standar cos not all the
db's can report it check my documentation:
http://gambaswiki.org/wiki/howto/odbcdatabase#t7

BUT STILL ARE NOT WORKING odbc module are broken changed to devel
environment after investigate it,   the culprit is the benoit's commits
changed behaviour that produces this new error 😈 (yeah benoit i must take
your attention on this and you too zxmarce):
https://gitlab.com/gambas/gambas/commit/aa67ba1309bde70e8b528be833ba06a8d124cbd1
maybe that's why i cannot reproduce in gambas 3.9 and 3.11+ has that
problem..
https://gitlab.com/gambas/gambas/commit/e07ac2e4f2588f62bb55aa2b8351a08a810c1586

i not teste 3.14 neither 3.15 yet.. cos i not backported the very bad made
ppa packages yet.. and debian ones limits the features.. (not qt4 not
sqtlie2  etc etc etc)

Lenz McKAY Gerardo (PICCORO)
http://qgqlochekone.blogspot.com


El vie, 22 de ene. de 2021 a la(s) 10:18, Benoît Minisini (g4mba5 at gmail.com)
escribió:

> Le 22/01/2021 à 15:13, KKing a écrit :
> > So my original issue may be related to mdbtools and debian in that most
> > doco suggests the odbc.ini Driver setting should relate to the section
> > name in /etc/odbcinst.ini in Debian mdbtools standard install would be
> > [MDBTools] but this fails with isql and only works if the odbc.ini
> > Driver setting points to the actual driver file in
> > /usr/lib/..../libmdbodbc.so
> > I am guessing the Gambas odbc component is not coping with this... will
> > try to look into the gb.db.odbc code.
> >
> > But I also have a another odbc question. While trying to test out if it
> > is more mdbtools and or debian I have setup a test to point to a sqlite
> > db via odbc (yes I know gambas can go direct)
> > isql select * from sampleTable returns 1,000 records ... but the
> > following Gambas code only returns the first record?
> >>   Dim $con As New Connection
> >>   Dim intCount As Integer
> >>   Dim rs As Result
> >>   Dim $ExecCmd As String
> >>
> >>   Try $con.Close()
> >>   $con.Type = "odbc"
> >>   $con.Host = "mysqlitedb"
> >>   $con.Open()
> >>
> >>   $ExecCmd = "SELECT * FROM sampleTable "
> >>
> >>   rs = $con.Exec($ExecCmd)
> >>
> >>   intCount = rs.Count
> >>
> >>   While (rs.Available)
> >>     Print "s_seq:" & rs!s_seq
> >>     rs.MoveNext
> >>   Wend
> >>
> >
>
> It's hard for me to help, as I don't know ODBC and didn't write the driver.
>
> But I know that the ODBC driver exposes many ways of browsing the result
> of a query, and I guess the failure is related to that. Maybe failing to
> use the accurate request browsing method, and/or detecting the end of
> the query result list... ?
>
> --
> Benoît Minisini
>
> ----[ http://gambaswiki.org/wiki/doc/netiquette ]----
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20210122/c9f6370b/attachment.htm>