Re: trigger question

> parris_at_duart.esp.bellcore.com (Parris Geiser) writes:
> Hi,
> We would like to execute a trigger when a record is
> inserted, but only if the transaction commits.
> That is, if the user inserts a record and then subsequently
> does a rollback, we don't want the trigger to fire.
> Is there any way to do this?
> Thanks for your help.
> parris
>>>>

This is how triggers behave by default.

Well, not precisely. To be more specific, any updates made by a trigger are rolled back with the rest of the transaction, because the trigger is considered part of the transaction.

Michael Stowe
Constellation Engineering, Inc.
http://www.mcs.com/~stowe Received on Thu Mar 28 1996 - 00:00:00 CET