[Gambas-user] ODBC component fixing

[PICCORO McKAY Lenz]

zxMarce i requested a virtual machine to test against sybase DB .. maybe
tomorrow will have a response to you..

ODBC standar does not support cursor in principe.. neither count.. in fact
some ODBC adapters just count in low level the results using subquerys.. a
dirty hack ..

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


El dom, 4 de abr. de 2021 a la(s) 17:28, Benoît Minisini (g4mba5 at gmail.com)
escribió:

> Le 04/04/2021 à 22:48, d4t4full at gmail.com a écrit :
> > Benoît,
> >
> > Trying as hard as I can.
>
> Don't be in a hurry. If you don't find now, I will release a 3.16.1 with
> the fix.
>
> > I may have found a problem already, but no solution yet.
> >
> > There's a place where a *SQLFetchScroll()* is used instead of
> > *SQLFetch()*, but replacing it made the component fail differently.
> >
> > The difference, obviously, is because the use of MDBTools. It does not
> > support cursors, so no record counting.
> >
> > I'll compare the ODBC calls in my isql-like app against the ones used in
> > Gambas. Maybe something is missing or should not be there.
>
> At worst, you can make 'gb.odbc' adapt its behaviour if a mdb connection
> is detected. When ODBC is horrible, dirty hacks are allowed. :-)
>
> --
> 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/20210404/deec0b1a/attachment-0001.htm>