Re: after statement trigger, updating table

Date: 7 Oct 1994 21:00:36 GMT
Message-ID: <374ctk$>

In <36ua7p$> (Franz Achermann) writes:

>I have the following problem:
>I would like to make an 'UPDATE' on table A, with every 'INSERT' of
>a row into table A.
>I cannot use 'after row trigger' since table A is locked, when
>doing an insert of several rows. So I would like to use an after statement
>trigger, looping over all inserted rows, and doing the correct update.
>How can I select exactly these rows, which has been entered by the
>INSERT Statement causing the after statement trigger to fire ?
>I see one solution:
>using a row trigger, which stores each ROWID of table a when insered into
>an external table. The after statement trigger then reads this external table,
>is doing the update of Table A, and deleting the external table (or at least
>all rows in it).
>Big honor to the one, proposing a better solution.
>Franz Achermann (

Hi Franz,

I think that you can use the BEFORE row trigger and take the new values of the fields by prefixing it with :new. This way, you will not have the locking problem.

Vijaya Kumar Nair Received on Fri Oct 07 1994 - 22:00:36 CET

Original text of this message