Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DELIMITER //
- CREATE trigger VERIFICAENCERRADA BEFORE UPDATE ON ocorrencias
- FOR EACH ROW
- BEGIN
- SET @descricao_resolvida = NEW.descricao_resolvida;
- IF ((SELECT stage FROM ocorrencias WHERE OLD.stage = 3) AND (CHAR_LENGTH(@descricao_resolvida) < 1) )
- THEN
- SIGNAL SQLSTATE '45000'
- SET MESSAGE_TEXT = 'Deve-se digitar uma descrição no encerramento.';
- END IF;
- END //
- DELIMITER //
- CREATE trigger VERIFICAENCERRADA BEFORE UPDATE ON ocorrencias
- FOR EACH ROW
- BEGIN
- SET @descricao_resolvida = NEW.descricao_resolvida;
- IF ((OLD.stage = 3) AND (CHAR_LENGTH(@descricao_resolvida) < 1) )
- THEN
- SIGNAL SQLSTATE '45000'
- SET MESSAGE_TEXT = 'Deve-se digitar uma descrição no encerramento.';
- END IF;
- END //
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement