[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