Re: Trigger syntax for inserting values in current row?

On Thu, 9 Jul 1998, Richard Ray wrote: > I want an ON INSERT trigger on a table to do some selects from other > tables in the database and update columns of the row that was inserted to > fire the trigger. Seems simple enough, but for the life of me I can't > figure out the syntax! It's pretty obvious how to upate _other_ tables, > but not the one I'm working from. Prior to version 7.3, there definitely was no syntax to allow you to edit what was inserted into the database with a trigger. There was a discussion of this in c.d.i earlier this year, and I contributed to it so you could probably find that discussion via DejaNews (www.dejanews.com). I think I heard, but I have not verified, that this has been relaxed with the 7.30 servers. You'd have to go digging in the documentation, probably under CREATE TABLE. Yours, Jonathan Leffler (jleffler@informix.com) #include <witticism.h> Guardian of DBD::Informix -- see http://www.perl.com/CPAN