2017-05-24 14:21 GMT-04:00 Cristiano Guadagnino <crigu...@gmail.com>:
> PICCORO, the usual way to know if a sql statement succeeded or not is by > checking the sqlcode. > Negative sqlcodes indicate a problem. > Odbc should support returning sqlcodes to the caller. > Can you check if you have any sqlcodes returned to you in the results? > oh men i not cheked that.. i asumed always return -1 lest try and report feedback here! > Oh and btw... What's wrong with using a try/catch? > > Cris > > > Il 24 mag 2017 7:35 PM, "PICCORO McKAY Lenz" <mckaygerh...@gmail.com> ha > scritto: > > > umm any idea : how can i know if using odbc a DDL like CREATE or DROP > TABLE > > was executed correctly without error , BUT using the result object and > not > > a try/catch block! > > > > Lenz McKAY Gerardo (PICCORO) > > http://qgqlochekone.blogspot.com > > > > 2017-05-24 10:07 GMT-04:00 PICCORO McKAY Lenz <mckaygerh...@gmail.com>: > > > > > 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 > > > ------------------------------------------------------------ > ------------------ > 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 > ------------------------------------------------------------------------------ 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