[Gambas-user] [Gambas Bug Tracker] Bug #726: Result object does not retrieve data when using ODBC driver.

[bugtracker at ...3416...]

http://gambaswiki.org/bugtracker/edit?object=BUG.726&from=L21haW4-

M. L. reported a new bug.

Summary
-------

Result object does not retrieve data when using ODBC driver.

Type             : Bug
Priority         : Medium
Gambas version   : 3.8.90 (TRUNK)
Product          : Database component


Description
-----------

Regardless of what ODBC connection method you use (older DSN or newer ConnectionString), the Result object misbehaves:

o- It does not retrieve query data,
o- Its .Available property is always FALSE,
o- It ignores .MoveXXXX methods.

But, on the other hand, it does fill its ResultFields collection with proper field data (name, type, etc).
I discovered an ODBC-specific patch by Andrea Bortolan explicitly removed in CResult.c with a "#if 0 ... #endif" block.
Tried to reactivate the patch with some degree of success (made the Result return only the first record).

Details in the attached project. Did not try with any other driver than ODBC, as I'm trying to get ODBC working as it should.

Note that older versions of Gambas 3 were able to retrieve data, at least with some effort, so I think there was a subtle change down the road that forced the patch removal and crippled ODBC.