Re: trigger question

Tab Liao (giodah_at_ms1.hinet.net) wrote:
> kasten_at_brookings.net (Chris Kasten) wrote:
 

> >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
 

> PRE-INSERT should fit what you want.

> Tab Liao.
> giodah_at_ms1.hinet.net

Tab,

	Thanks for your answer, but what is PRE-INSERT?
	The CREATE TRIGGER has two options: BEFORE and AFTER.
		parris