Currently, I am working on a project where I need to cascades deletes in SQL 7.0. I have a table called disc and another called disc_notes. I am trying to create a trigger that cascades the delete of an entry in disc so that it also deletes all the entries in disc_notes that refer to the entry in disc. There is a foreign key relationship set up between these to tables based on fields called disc_cnum and disc_num. From your example, I tried this:
CREATE TRIGGER disc_delete
AS DELETE FROM disc_notes WHERE disc_cnum, disc_num IN
(SELECT disc_cnum, disc_num
And I got this error:
Error 107: Line 4: Incorrect Syntax near ‘,’.
I was wondering if someone could take a look at this and offer me some advice. Thanks.
"There is no normal life, Wyatt. There is just life"