Re: Is there a workaround for the 'mutating table' problem in a trigger ?

From: Rob Benson <robben_at_theta.co.nz>
Date: 1996/04/15
Message-ID: <31726A87.353D_at_theta.co.nz>#1/1


coolcat_at_citynet.net wrote:
>
> Hi
>
> In a trigger on a table, I want to do a
> SELECT MAX() ...
> from that table and update a denormalized column in another table.
> .....
> TIA.
In earlier releases (7.1.3 back I think) you could get around this by selecting from a view based on the table concerned BUT I notice in 7.1.6 that this no longer works. Will get back to you if I think of a work around.

-- 
**************************
Rob Benson
Theta Systems Limited
robben_at_theta.co.nz
http://theta.co.nz/theta
Received on Mon Apr 15 1996 - 00:00:00 CEST

Original text of this message