Re: assign default values in trigger - solved

[jakub]

first - thank you for your advice - my solution:

//edited

	DECLARE newid MEDIUMINT(5);
	

	IF NEW.`timestamp` IS NULL OR NEW.`timestamp`='0000-00-00 00:00:00' OR NEW.`timestamp`='' THEN
		SET NEW.`timestamp` = NOW();
	END IF;

	IF NEW.`id` IS NULL OR NEW.`id`='' THEN
		CALL getNewStructureId(newid);
		SET NEW.`id` = newid; 
	END IF;

Edited 1 time(s). Last edit at 10/15/2006 01:51PM by jakub .