Trigger After update of and rollback
Suppose I have a value Balance. I attempt to subtract an amount
that is greater than Balance. Therefore Balance is negative.
Of course, I don't want that. I have been told the best way to
address this is an After Update of with a Rollback in there.
Assuming that this works, then this would revert the balance to
a form before it was updated.
There is also a Transaction table which is supposed to log these
transactions as they are processed. The transaction is inserted
into the table AFTER the balance has been updated. Does the
procedure terminate when the trigger is fired and the negative
condition is true, or does it roll back the transaction the same
way the balance was rolled back?