Re: insert ROW LEVEL trigger question
Posted in 1995
Roger Tomas — — source: Informix-list mailing list archive (1991-1998)
rt10hp@csl.gov.uk (Richard Thomas) wrote: > >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! I can't say I've tried that one, but I have tried making the trigger invoke a stored procedure which turns around and attempts to update the triggering table. This doesn't work which makes me suspect your idea won't work either. Roger Tomas AG Communication Systems