[Gambas-user] A question for Lee
gradobag at gradobag.it
Thu Aug 10 11:31:46 CEST 2023
Il 10/08/23 09:18, Marco Ancillotti ha scritto:
> Il 10/08/23 07:48, BB ha scritto:
>> Gianluigi, the issue is well described by Marco "database is m$ sql
>> server , I use odbc to connect and it works... BUT i cannot enumerate
>> the results as there some bug in the odbc driver ( witch I can't
>> change )"
>> In other words, the ODBC *driver* (not the Gambas odbc component) has
>> a bug (that he has later stated has been recognized and patched) that
>> the sysadmins wont support. Which is ridiculous but such is politics
>> in the modern organisation!
>> So the driver wont enumerate and therefore the Gambas Result objects
>> wont enumerate.
> Hi Gianluigi , the answer from BB is right , I can't enumerate the
> result so if I read it line by line it works but if I say somethink like
> "go to the 31st line" it don't work and I get the first line.
> For that bug for every query I need to read all the result line by
> line and save it to a collection where I can search without any problem.
Hi Marco & Bruce
Thank you very much for the explanations, to make sure I understand the
- ODBC is able to return the result with all the tuples of the query.
- Unfortunately the result is not enumerated.
- If we try to use the result in the traditional ways it will fail.
- We need to read the result one tuple at a time and save it as shown by
Another thanks to all of you :-)
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the User