Trigger Question
From: Gerald Gruber <gru_at_trench.at>
Date: Tue, 20 Nov 2001 08:12:45 +0100
Message-ID: <9td13i$86f$1_at_newsreader1.netway.at>
Hi!
Date: Tue, 20 Nov 2001 08:12:45 +0100
Message-ID: <9td13i$86f$1_at_newsreader1.netway.at>
Hi!
[Quoted] How to solve this problem?
[Quoted] I have a table TAB1 with some fields in it. There is a trigger on update of field FLDn. In this trigger I want to calculate the number of rows in TAB1 that have the same value as the triggered row.
Something like:
[Quoted] select count(*) into i from tab1 where fld3 := :new.fld3
[Quoted] in an update trigger won´t work, because the SQL-Statement may not see the triggered row.
[Quoted] Any suggestions to solve my problem?
Thank you
Geri
Received on Tue Nov 20 2001 - 08:12:45 CET