What am i doing wring mysql

[Meyer]

We are using Info @ hand and the workflow has a bug.

If you do a workflow in case to create a task, it creates over 500 tasks. thus the reason i am trying this script.

What i am trying to achieve is when case status equels -- to create a task calledd --. but in this script it keeps creating the tasks everytime i edit a case and the status stays the same, or even when i edit the task a new task gets created.
How would i be able to fix this, or does someone know how to fix the info@hand workflow from multiplying.

DELIMITER $$

USE `======`$$

DROP TRIGGER /*!50032 IF EXISTS */ `Cases`$$

CREATE
/*!50017 DEFINER = 'eeeeee'@'localhost' */
TRIGGER `Cases` AFTER UPDATE ON `cases`
FOR EACH ROW BEGIN
INSERT INTO tasks (id,date_entered,date_modified,assigned_user_id,mo dified_user_id,created_by,
NAME,STATUS,date_due_flag,date_start_flag,parent_t ype,parent_id,priority,description)

SELECT MD5(RAND()) AS id,
CURDATE()AS 'd1',

CURDATE() AS 'D2',

assigned_user_id,

modified_user_id,

created_by,

CASE

WHEN STATUS = 'Obtain Info' THEN 'Gather Info'
WHEN STATUS = 'Contact Client' THEN 'Contact Client to get more info'
END AS 'taskname',
'Not Started' AS 'caseSTATUS',
'on' AS 'on121',
'on' AS 'on1',
'Cases' AS 'beantype',
cases.id AS 'Caseid',
'p2' AS 'peep',
CASE
WHEN STATUS = 'Obtain Info' THEN 'Gather all relevant information need to assist the SP'
WHEN STATUS = 'Contact Client' THEN 'Contact Client to get more info'
END AS 'description'
FROM cases
$$
DELIMITER ;

[kbrill]

Not sure anyone here would be able to help, most of us are MySQL users and I'm not sure any of us would do that with a trigger, we would use a logic_hook in SugarCRM itself. Not that using a trigger shouldn't work or is a bad choice, its just not the normal choice when working in SugarCRM.

[Meyer]

Hi thanks

i got it right with insert ignore, and changing my mds.

But i would love to know how to do a logic hook. as i am not a programmer but a normal administrator with minimum knowledge.

and we use info@hand wich is built on sugar 4.5.

please explain how i could create a logic hook from case to create a task?

regards