How to trigger "UPDATE" to decline updation on particular day?
Posted by: megat haikal
Date: July 30, 2007 09:41PM

Hello
I have problem with trigger function.I want to trigger an update function to decline any updation on particular day;for my problem it's Sunday.I paste the code and i hope you guys can help me

create trigger NoUpdateSeatsOnSunday
ON reservation
FOR UPDATE AS
IF(SELECT no_of_seats FROM inserted)<unknown syntax>
BEGIN
PRINT 'You cannot update on Sunday'
ROLLBACK TRANSACTION
END

thanks in advance

Options: ReplyQuote


Subject
Written By
Posted
How to trigger "UPDATE" to decline updation on particular day?
July 30, 2007 09:41PM


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.