Re: can't triggers reference to tables?(another question)
Posted by:
Chagh
Date: June 25, 2005 11:10PM
and another question(so sorry to take your time). for the trigger below how can i select from deleted in MySQL?
should i use :"where RelatedDocCode like old.doccode"?
SQLServer trigger:
"CREATE TRIGGER DeleteDocument ON [dbo].[_Documents]
FOR DELETE
AS
DELETE
FROM _RelatedDocs
WHERE RelatedDocCode IN ( SELECT DocCode
FROM DELETED ) "
Thanks in advance
Chagh
Subject
Written By
Posted
Re: can't triggers reference to tables?(another question)
June 25, 2005 11:10PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.