Re: Trigger

kpdp wrote:

> Hello,
>
> I want to make a trigger which does in a table :
> Colunm 3 = Colunm 2 + Colunm 1 each time I update Column 2 or Column 1
>
> If tried without success:
>
> CREATE TRIGGER my_trigger
> AFTER
> UPDATE OF my_col1, my_col2 ON my_table
> FOR EACH ROW
> BEGIN
> UPDATE my_table SET my_col3 = my_col1 + my_col2 ;
> END;
>
> It doesn't work, do you have an idea ?
>
> Thanks in advance

Write something like this.

:NEW.my_col3 := :NEW.my_col1 + :NEW.my_col2;

A trigger is no place for an update statement on the host table.

Daniel A. Morgan Received on Fri Jun 29 2001 - 12:15:20 CDT