Thomas Steinmaurer wrote>

>
> A trigger will fire when you commit the transaction in which the DML
> statement was executed. No COMMIT = the trigger won't fire.

Errr, I think not. The a before action trigger fires before the action,
followed by constraints, then the action, then after triggers. The
cancel query will undo all the actions, including the triggered action.
The whole package, before action triggers, action, and after action
triggers and any other changes caused by the changes is atomic - it will
succeed or fail as a unit.

It's events that occur on commit.

Cheers,


Ann