Hi,
Il 06/09/2018 10.41, Karol Bieniaszewski liviusliv...@poczta.onet.pl
[firebird-support] ha scritto:
If you need to update same table then „before” update trigger is the
best choice.
>>Updating another table from a Before trigger is made in a transaction
>>that rolling back if exception occurs?
If you do not run it in different transaction context - like IN
AUTONOMOUS TRANSACTION - then yes
Ok, I think I asked an incorrect question
I could explain better:
Updating another table from a Before trigger is made in a transaction
that rolling back if exception occurs even I have hundred rows in table
that fire a before insert/update trigger and if the exception occurs in
hundredth row? or trigger is fired row by row in table and this
behaviour not occurs and the update made by row 1..99 are confirmed even
occurs an exception in row 100?
Thanks.
--
Luigi Siciliano
--------------------------