Version 9 Triggers / Store Procedures

[rusk1]

Hi,

Can anyone tell me if there are any differences in the syntax of Triggers or Stored Procedures in V9? We have recently upgraded to V9 and have a couple of triggers that I need to recreate. When I run the statement below I get a syntax error. This works fine in V8.x.

Any assistance would be appreciated. Cheers,

Russ.

CREATE TRIGGER ins_history
BEFORE INSERT ON history FOR EACH ROW 

DECLARE
:v_last_history_id DOUBLE = 0;

BEGIN
-- Selects the last used HISTORY_ID
SELECT	IFNULL(MAX(history_id),0)
INTO	:v_last_history_id
FROM	history;
		
-- Updates the new history_id with the last used id + 1   
SET NEW.history_id = :v_last_history_id + 1;

-- Updates with String Version of Current Date
SET NEW.date = 	SUBSTRING(CONVERT(CURDATE(),SQL_CHAR),1,4) + SUBSTRING(CONVERT(CURDATE(),SQL_CHAR),6,2) + SUBSTRING(CONVERT(CURDATE(),SQL_CHAR),9,2);

-- Update Time
SET NEW.time = 	HOUR(CURTIME())*3600 + MINUTE(CURTIME())*60 + SECOND(CURTIME());
	
END;