Re: Database Triggers Question

From: Alan D. Mills <alanm_at_uk.europe.mcd.mot.com>
Date: 1997/12/30
Message-ID: <01bd153d$ffcd39b0$73d0658c@ukmhdam>#1/1

Thanks. Just what I wanted.

Also thanks to Jim Kennedy who emailed me directly

Alan

Graham Miller <lgmiller_at_elmrd.u-net.com> wrote in article <34a91187.1133157_at_news.u-net.com>...
> hello,
> Use the conditional tests:
> INSERTING
> or UPDATING
> or DELETING
>
> which return true or false depending on the executing statement.
>
> e.g.
>
> IF INSERTING then
> do InsertLogic( :new.field1 );
>
> ELSIF UPDATING then
> do UpdateLogic( :Old.Field1, :New.Field1 );
>
> ELSIF DELETING then
> null;
>
> END IF;
>
> merry new year
>
> graham
>
Received on Tue Dec 30 1997 - 00:00:00 CST