Re: Trigger syntax for inserting values in current row?

Posted in 1998

Roger Tomas — Fri, 10 Jul 1998 07:29:07 -0700 — source: Informix-list mailing list archive (1991-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. > > Pointers? Is there more/better documentation available on trigger and stored > procedure syntax than what's in the Informix books? > > +-----------------------------+-------------------------+ > | Richard Ray | richard_ray@xbd.com | > | Excellence by Design, Inc. | 307.739.0707 (voice) | > | PO Box 30445 | 307.739.2592 (fax) | > | Jackson, WY 83001 | | > +-----------------------------+-------------------------+ You need 7.3 to do what you want. Earlier versions did not allow insert triggers to update the triggering table. Roger Tomas AG Communication Systems