[Gambas-user] [Gambas Bug Tracker] Bug #1102: ODBC driver super buggy 3: impossible made subquerys if the previous its a call/select to SP

[bugtracker at ...3416...]

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

Comment #3 by PICCORO LENZ MCKAY:

hi zxMarce, really really thanks for your support, about the subquery problem? seem when i have open result (opened cursor i think, with forward only) cannot made another query without free the previous result object, or cursor.

that's the principal topic in this bug #1102, i'm not expert but the piece of code dont work in some odbc cases, specially with freetds (i cited that due i already know you can have it and can access a TDS-like db)

query1 = "select col1, col2 from table1 " '
query2 = "select count(*) as total from table1"  '
Try rs2 = $conexionodbc.Exec(query2)
    If rs2.Available Then  ' 
        print rs2!total
        try rs1 = $conexionodbc.Exec(query1)      ' BUG this raise a problem, no rows and some times !
    Endif

that piece of code works with mysql only.. (and i'm tyred of mysql je jeje)