[Gambas-user] how to manage mysql error in gambas ?

[Marc Guillaume]

hi everybody,

I would like to use the mysql error handling when I try to make a mysql
insert that generates a "Duplacate entry" error in mysql to be able to
transform the query into an update of one of the table fields. But
Gambas returns the -1 error whatever the mysql error generated. I can
parse the mysql error message that is returned, but is there a way to
retrieve the specific error number from MySQL? 

Otherwise I'll try to use a stored procedure. 

thanks for your help