So you both advise me to set transactions to manual?

pseudocode

set transactions to manual
tableupdate father table
if ok then tableupdate childtable
if any of the above fail, then rollback, otherwise, commit
finally set transactions to automatic

OK, I'll try that

Thank you both
Rafael Copquin