Re: [Gambas-devel] Change to gb.db.odbc to use ODBC Connection Strings.

[PICCORO M. L. <mck...@gm...>]

connection strings are since gabmas 3.7 ? this will break backguard
compatiblity...

about odbc and some bugs present, the multicursor fetch are a freedts
limit, already reported and tested by me among others in freetds
project contribution

> Le 16/10/2015 ? 19:20, ML a ?crit :
>>
>> Beno?t,
>>
>> Well, I was speaking about SQL-92 and the like...
>>
>> ODBC has a way to fetch a block of rows. You can set how many. Then, it
>> will retrieve (up to) that many rows from the rowset.
>> You can, IIRC, also specify the starting offset. All this, of course, as
>> long as the Driver or RDBM provides scrollable cursors.
>> Mind you, I never tried a row-block fetch, and it will be a demanding
>> 'challenge' to overcome. My guess is that it will take some time.
>>
>> Please tell me how can gb.db.odbc know whether someone used the
>> DB.Limit() property, so I can make the next fetch a row-block fetch, and
>> how to recognize a "go back to retrieving 1 row at a time" mode change.
>> Related to that, one of the things that still escape me is which calls
>> in gb.db map to which (block of) calls in gb.db.odbc. That, and which
>> high level Gambas calls map to which gb.db (block of) calls.
>>
>> Regards,
>>