Re: Trouble with Triggers

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Tue, 15 Oct 2002 08:38:36 +0200
Message-ID: <kpdnqugdved4t48rlo5c0oqivfh1u8n9o7@4ax.com>

On Tue, 15 Oct 2002 04:51:00 GMT, "Schrödinger's Cat" <72446.2772_at_compuserve.com> wrote:

>TriggerStats after update on Trade for each row
>begin
> update Trade set column1 = column3 - column2;
> -- etc...
> -- column3 is new and column2 is old
> -- tried all sorts of variants: select :new.column3 - old:column2 into
>:new.column1 from DUAL; -- this required changing "after"
> --"before" :new.column1 := new.column3 - old:column2 ;
> -- also tried :new.column1 := new.column3 - old:column2 ;
>end;

need to change into

TriggerStats before update on Trade for each row

changed after into before begin :new.column1 := :new.column3 - :old.column2 ; end;

At least this is the appropiate syntax.
Not sure what you are upto and why you can't merge the trigger into the actual update.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Oct 15 2002 - 01:38:36 CDT