RE: Triggers
----------
From: Svolos, Spyro
To: informix-list-owner(a)rmy.emory.edu; Sood(u)Niraj/SO(a)instru.fi
Subject: RE: Triggers
Date: Tuesday, September 16, 1997 6:14PM
Sood,
Informix's poor implemenation of triggers does not allow the trigger to
change the triggering row for an insert trigger. You can do this for update
triggers. For inserts you may be able to get by setting defaults.
Good Luck
Spyro Svolos
i compute, INC.
----------
From: informix-list-owner(a)rmy.emory.edu; Sood(u)Niraj/SO(a)instru.fi
To: informix-list(a)rmy.emory.edu
Subject: Triggers
Date: Tuesday, September 16, 1997 11:10AM
Hi every,
Is it possible to launch trigger on the table itself. For example I'm
running the following trigger and I get -747 error. According to
Informix syntax is Ok!
CREATE TRIGGER up_medtabinsertINSERT ON measurement
FOR EACH ROW
(UPDATE measurement
SET Phone_Number = '999-777770'
WHERE measurement_event = 'CA' AND measurement_id = 9999));
Thanks for your help.
niraj sood
niraj.sood@instru.fi
<<File Attachment: TRIGGERS.BIN>>