Re: Help with Trigger

From: Matthias Geigulat <MGeigulat_at_gmx.de>
Date: Tue, 29 Aug 2000 07:14:25 +0200
Message-ID: <8ofgsv$jr0$15$1@news.t-online.com>

Hi Janette,

try it this way:

CREATE TRIGGER scott.biu_table1

    BEFORE
    INSERT OR UPDATE OF Field_1 ON scott.table1     FOR EACH ROW
    BEGIN
        :new.Field_5 := :new.Field_1;
    END; Matthias

"Jannette" <jannetteyiu_at_my-deja.com> schrieb im Newsbeitrag news:8of9ss$u0b$1_at_nnrp1.deja.com...
> Please help me with this short Trigger, I just can't make it work:
> After each insert or update on Field_1, I want the Trigger to write the
> new value of Field_1 to Field_5 (of the same table).
>
> Thanks a lot !
>
> Jannette
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Aug 29 2000 - 00:14:25 CDT