> Do you understand that, if the operation on Table B fails and you

roll back

> the transaction, then anything done by triggers also gets rolled back?
>

Yes, Iam aware of that. Well I guess I just have to take your word
that triggers will always fire. I assume that you find no problem at
all with my coding on my trigger. Is this ok ... set request = request
+ new.requestqty ...

Because some suggest me to get the original value first then put in on
the variable, then make use of the variable ... but I think we can't
declare and use variable in trigger ...

Thanks for you help =)