please pardom me, i explain me better: i mean: how can i know if a DDL like CREATE or DROP TABLE was executed correctly without error , using the result object and not a try/catch block!
Lenz McKAY Gerardo (PICCORO) http://qgqlochekone.blogspot.com 2017-05-24 9:58 GMT-04:00 Benoît Minisini <gam...@users.sourceforge.net>: > Le 24/05/2017 à 15:47, PICCORO McKAY Lenz a écrit : > >> due the odbc does not provide a record count like mysql does (cos provider >> may o nor offer) on every sql query.. >> >> how we can know if a DDL sql (i mean a select, a dropt table, or a create >> table) was excecuted using the result object and without a try catch >> method? >> >> >> Lenz McKAY Gerardo (PICCORO) >> http://qgqlochekone.blogspot.com >> > > The record count is only for Result objects. So you should not get it for > a CREATE or a DROP TABLE statement. > > A record count of -1 means that you have to use the MoveNext() method > until the Available property is False to get each record. Once done, then > you know how many records you get. > > I think the reason is that the underlying ODBC driver sends the result > line by line, whereas the others (MySQL, PostgreSQL and SQLite drivers) > send all the lines by default. > > Maybe the ODBC driver should store the entire query result in memory to > simulate a standard Result object when it is internally "move forward" only? > > -- > Benoît Minisini > ------------------------------------------------------------------------------ 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