MySQL Forums
Forum List  »  Triggers

check two columns
Posted by: Stefan Elwesthål
Date: December 08, 2005 12:19AM

Hi all.

I need to write a trigger that checks that at least one of two columns has a value before accepting a post. (there has to be one customernumber, either delivery customer or invoice customer or the order shouldn't be accepted)

Are there any examples of how this could be accomplished?

Regards

Options: ReplyQuote


Subject
Views
Written By
Posted
check two columns
2712
December 08, 2005 12:19AM
1518
December 08, 2005 12:33AM
1968
December 08, 2005 12:46AM
2294
December 08, 2005 12:54AM
1862
December 08, 2005 12:59AM


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.