[Gambas-user] odbc a way to know if a sql DDL was susessfully or not?

[PICCORO McKAY Lenz]

2017-05-24 14:21 GMT-04:00 Cristiano Guadagnino <criguada at ...626...>:

> 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" <mckaygerhard at ...626...> 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 <mckaygerhard at ...626...>:
> >
> > > 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 <
> gambas at ...1...>
> > :
> > >
> > >> 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 at 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 at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>