Re: INSERT & UPDATE TRIGGERS ON SAME TABLE

At 13.27 12/02/97 -0800, you wrote: }Hi, } }I execute a trigger to log the record that is being updated on table A --- 1 } }I also execute a trigger when I insert a record on table A. This logs }the record. --- 2 } }My question is can I do an update on a certain field to the record that is }being inserted on Table A in the form of a stored procedure when I am }executing the trigger stated under 2. I want to update a field in Table A }for the record that is being inserted. } }My problem is during an insert I have to update the record and also log }the record. Is there any other way to do this other than the trigger? } }Please email me directly } }Sham }smvaidya@auto.rockwell.com } I have a similar problem. With an INSERT I put a record R in table A; to complete the insert of that record R, I use the stored procedure S (that is activated by a trigger T during the INSERT) that updates some fields of record R. Informix (OnLine Dynamic Server - Version 7.1) does not allow me to do this. Does anybody know a way to do this with a similar use of triggers + stored procedure or in some other way? Thanks for your attention _____________________________________________________________________________ Paolo Mancuso - Gesi Srl - Via Rodi, 32 - 00195 ROMA - Tel. + 39 6 39743413 _____________________________________________________________________________