[Gambas-user] A question for Lee

[Gianluigi]

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.
>
> Bye,
>
> Marco.
>

Hi Marco & Bruce

Thank you very much for the explanations, to make sure I understand the 
summary:

- 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 
Lee.

Another thanks to all of you :-)

Gianluigi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20230810/5c701ffc/attachment-0001.htm>