Re: insert ROW LEVEL trigger question

jregep@zenacomp.zenacomp.com (John Regep) wrote: >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? Call Informix Tech Support and tell them to add your name to the list of users requesting this feature. The feature request number is 2566 and was originally submitted 9/2/93. Roger Tomas AG Communication Systems