Re: instead of triggers for a view

TRIGGER trigger_name_trg
  instead OF UPDATE ON view_name
  FOR EACH ROW
BEGIN UPDATE table_name t

    SET t.column1 = :NEW.view_column1,

	t.column2 = :NEW.view_column2
	WHERE t.id= :OLD.id;

...
...
...

END; Jan Received on Fri Dec 07 2001 - 01:15:36 CST