Re: updating a referencing field via trigger

From: Wassim <net2000_at_francemel.com>
Date: Sat, 29 May 1999 18:51:54 GMT
Message-ID: <7ipd0a$fs6$1@nnrp1.deja.com>

In article <374FD4C0.528F0520_at_orbital-computer.de>, Thomas Bierhance <Bierhance_at_orbital-computer.de> wrote:
> Hi,
>
> I'm having a problem in following situation. There is a table 'A' that
> references another table 'B'. When deleting a row in table 'B' I want
> the reference in table 'A' set to NULL. I created a trigger for that:
>
> before delete on B for each row

....

im not sure of my answer but first idea that came to me when i read ur message is that tigger had to b defined AFTER delete not BEFORE? is it true?
hope it'll be !

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sat May 29 1999 - 13:51:54 CDT