Re: Validation Trigger

[Oliver Taylor]

Ok thanks,

Where would that go?
If I used the SIGNAL rule would I use it inside the trigger?

Something like this:
-- Trigger DDL Statements
DELIMITER $$

USE `spikes`$$

CREATE
DEFINER=`root`@`localhost`
TRIGGER `spikes`.`trigger1`
BEFORE INSERT ON `spikes`.`invoice_details`
FOR EACH ROW
BEGIN
IF NEW.due_date <= NOW() OR NEW.invoice_date <= NOW() OR NEW.shipping_total <=0 OR NEW.order_total <=0 OR NEW.total_cost <=0 THEN
CALL raise_application_error(1234, 'Error - check Date and value');
SIGNAL WARN
SET MESSAGE_TEXT = 'CHECK VAlUE';
END IF;
END$$

Is there any specific syntax?
Also does SIGNAL "" have to be any specific filed?