The actual problem now is that when this issue hits, GetRecordCount() will return the default -1 as count, making iteration in a SQLite table hard.
By "hard" I mean that data retrieved is garbage, and I do not yet know why. I'm looking into this latest development now.
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 '
try rs1 = $conexionodbc.Exec(query1) ' BUG this raise a problem, no rows and some times !
that piece of code works with mysql only.. (and i'm tyred of mysql je jeje)
now this its a confirmed bug: seems the odbc implementation for TDS protocol in gambas does not enabled the advanced cursor.. and uses the default cursor, that does not support subquerys (multiple cursor and moveto cursors)
ok, after some research MARS are supported in FreeTDS since version 0.95, its not enabled by default, so the problem here its that the gambas implementatin seems does not enabled the needed features..
PICCORO LENZ MCKAY changed the state of the bug to: Accepted.