MySQL Forums
Forum List  »  Triggers

trigger newb: Prevent certain records from being updated
Posted by: Steve Klett
Date: October 27, 2006 10:34AM

I want to prevent a record from being updated if it has child records.
I would also like an error to be raised if possible. That terminology might not make sense, like I said, I'm new to triggers (this is my first one) ;)

In other words, rather than just have the update fail or be blocked by the trigger, I would like it if I could somehow catch an error thrown by the trigger to disaply on the client.

I'm using the .NET connector.

I've searched for examples of triggers that return an error but haven't found anything.

I just need a kickstart on this trigger creation and I think I will be able to figure out the details. If anyone could show me a quick sample of hwo to return or print an error from a trigger, that would be fantastic.

Thanks for reading,
Steve

Options: ReplyQuote


Subject
Views
Written By
Posted
trigger newb: Prevent certain records from being updated
2489
October 27, 2006 10:34AM


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.