Re: how to do ON MODIFY CASCADE?

From: <prochak_at_my-dejanews.com>
Date: Tue, 10 Nov 1998 15:46:41 GMT
Message-ID: <729n51$jbg$1@nnrp1.dejanews.com>

In article <364802B0.BBF5893_at_ipmultimedia.es>, Jesus Ciriano <jciriano_at_ipmultimedia.es> wrote:
>
> I've got a table with a foreign key to another table,
> and I'd like that if the value of the primary key referenced changes the
> value, the
> values in my table change to this new value automatically.
>
> I was searching for this and all that i've found is ON DELETE CASCADE
> but nothing
> about an ON MODIFY CASCADE.
>
> What can I do??
>
> Thankyou
> --
> J.Ciriano
> e-mail: jciriano_at_ipmultimedia.es
>
>

There isn't any MODIFY command so..
do you mean to trigger ON UPDATE???

--
Ed Prochak
Magic Interface, Ltd.
440-498-3702

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Nov 10 1998 - 09:46:41 CST