Re: insert ROW LEVEL trigger question

Hi! We haven't upgraded from 4.10 to 6.00 yet, so I haven't used triggers, = but shouldn't it be possible to get a trigger to update a "dummy" table, and = =20 then get a trigger on that table to update the original table. OK, it's not good performance-wise, and would use extra disk space, but it might just work! HTH (IWBAMIID!) Richard. ----------------------------------------------------------------- =20 | _ =AF\\ | Richard Thomas | | \\ 0_ | r.thomas@csl.gov.uk | | \\ / | | | oo/ | "20 Regal and a four-pack, | | / \\ | I guess I'm set for the night" | | \\_/ | - "TV Tan" The Wildhearts | ----------------------------------------------------------------- > 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?=20 >=20 > : 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. >=20 > : Roger Tomas > : AG Communication Systems >=20 >=20