Trigger

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 Received on Fri Jun 29 2001 - 09:33:02 CDT