Re: trigger question

parris_at_duart.esp.bellcore.com (Parris Geiser) wrote:

> 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

Isn't that a non-issue? You can't commit or rollback within the trigger so if the user does a rollback *everything* rolls back, no?

hth,

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Chris Kasten
Programmer/Analyst

#include <std/disclaimer.h>
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Received on Wed Mar 27 1996 - 00:00:00 CET