Hi All,

I am facing this error whenever I update a record in the table. I have AFTER UPDATE trigger is running on the TABLE to which I am trying to update the record.

The trigger is as follows:

-- Trigger definition script TR_u_Accounts_cdx_Merge for MySQL
-- Generated by (c) Ispirer SQLWays 3.9 Build 1010 EVALUATION VERSION
-- Timestamp: Thu Nov 08 11:28:36 2007

DELIMITER $$

CREATE TRIGGER TR_u_Accounts_cdx AFTER UPDATE
ON Accounts FOR EACH ROW
BEGIN

BEGIN
IF NOT(OLD.TMDate <> NEW.TMDate) then
UPDATE Accounts
SET ConcurDetect_X = 1+(CASE WHEN OLD.OrgID = OLD.OrgID THEN IFNULL(OLD.ConcurDetect_X,1)
END) WHERE Accounts.OrgID = OLD.OrgID;
END IF;
END;
BEGIN
IF NOT(OLD.TMDate <> NEW.TMDate) then
UPDATE Accounts SET TMDate = UTC_DATE() WHERE REPLGUID =
OLD.REPLGUID;
END IF;
END;
END;

$$


Please suggest me a solution.

Regards,
Mari.