[Gambas-user] odbc a way to know if a sql DDL was susessfully or not?
Benoît Minisini
gambas at ...1...
Wed May 24 20:32:20 CEST 2017
Le 24/05/2017 à 20:30, PICCORO McKAY Lenz a écrit :
> 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
>>
Failing SQL statements must raise en error that you have to catch with
the TRY or CATCH instructions.
Regards,
--
Benoît Minisini
More information about the User
mailing list