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

[PICCORO McKAY Lenz]

2017-05-24 14:30 GMT-04:00 PICCORO McKAY Lenz <mckaygerhard at ...626...>:

> 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?
>>
>
the code return as -1 meas TRUE in gambas, and where when false? i found
that behaviour:
1) if the sql was correct, returns "-1" that in gambas means TRUE (very
confusin respect odbc)
2) if the sql are bad or invalid, retun a null object so there's no "-1" or
whatever possible check!!!
3) if the sql are correct but the resuilt are not expected (i mean there's
no rows in table) returns "-1" too, that's the problem


​



> 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
>>
>
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: error-odbc.png
Type: image/png
Size: 29563 bytes
Desc: not available
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20170529/d8ee8c58/attachment.png>