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) ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user