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

[Cristiano Guadagnino]

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 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
>