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
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