Re: Generating an Error in a Trigger

2005-10-07 Thread Peter Brawley
Rob, >How do I generate an error condition within a Trigger? >This might sound a strange request to some but I'm trying to do input >validation on an insert/update query using a trigger. If the validation fails >I need to set an error condition such that MySQL will not Insert/Ammend the >data

Generating an Error in a Trigger

2005-10-07 Thread Rob Hall
How do I generate an error condition within a Trigger? This might sound a strange request to some but I'm trying to do input validation on an insert/update query using a trigger. If the validation fails I need to set an error condition such that MySQL will not Insert/Ammend the data. Whilst I