Re: trigger on insert: updating one value of the same table

Insert a row from the INSERT TRIGGER into another staging table containing the keys to the inserted row. Then a separate task can run or loop every N seconds that extracts new rows from the staging table, performs the update, and deletes the staging row. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Dec 10, 2009 at 3:38 PM, Gentian Hila <genti.tech@gmail.com> wrote: > I have a program that is closed to us. It inserts a new row, every > column of the table. > > I want one to update the value of one column on the inserted row. > > I tried a INSERT on trigger but since the column is included on the > insert it gives me the error: > > "table or column matches object referenced in triggering statement". > > Is there a way that I can achieve this through a trigger? > > That would be extremely helpful. > > Thank you, > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >