Re: insert ROW LEVEL trigger question

My manuals are at home , but here's what I remember being told: You can have a trigger for an update of a column, do an update on another column. You can not have a trigger for an update of a row, do an update on a column for that same row. This is so you don't cause an endless loop. IMHO Informix should protect itself from an endless loop. This way Every time a row is update THROUGH ANY MEANS (4gl app, isql, dbacess) audit trail fields (user_id , date, time, terminal_id) can be updated as well. Its nice to see that other people have noticed this too. I would like to see Informix address this. Anyone else agree? -- John Regep ZenaComp Roger Tomas (tomasr@agcs.com) wrote: : nigelc@Cognos.COM (Nigel Campbell) wrote: : >I cannot tell from the Online 7.x docs if I should be able to setup a row : >level insert trigger which assigns values to columns of the inserted row : >via calls to a stored procedure. As along the lines of execute procedure : >blat ... into col1, col2... in an update trigger. : > : >Ideas? : Don't know about 7.x, but in 5.01 an insert trigger cannot insert/update : the triggering table - it can only insert/update other tables. I believe : a feature request exists for this capability but have no idea whether : Informix intends to implement it. : Roger Tomas : AG Communication Systems