| Subject | After insert or after update trigger |
|---|---|
| Author | Raigo |
| Post date | 2004-06-10T14:11:03Z |
Is there some way to create a trigger what works both after insert and
after update?
someting like:
CREATE TRIGGER MyTrigger FOR MyTable AFTER INSERT OR AFTER UPDATE
POSITION 0 AS
BEGIN
if (new.MyDateField='30.12.1899') then update MyTable set
MyDateField=null where ID=new.ID;
END
after update?
someting like:
CREATE TRIGGER MyTrigger FOR MyTable AFTER INSERT OR AFTER UPDATE
POSITION 0 AS
BEGIN
if (new.MyDateField='30.12.1899') then update MyTable set
MyDateField=null where ID=new.ID;
END