UPDATE usermanagement SET usermanagement.tblClients_fldDRCClientID =
(
SELECT MAX(fldDRCClientID) AS MaxOffldDRCClientID
FROM tblClients
)
ORDER BY id DESC
limit 1;
the query above works but I have an event related issue. T1 triggers to T2 and I can't place this on T2 (as a new trigger) it conflicts with the T1 trigger and throws an error (not sure why). Any thoughts on where else it could go as a process related to passing the MaxOffldDRCClientID back to T1 after T2 record insert (I have tried both before and after insert and they both throw the same error saying it conflicts with the T1 trigger)
(
SELECT MAX(fldDRCClientID) AS MaxOffldDRCClientID
FROM tblClients
)
ORDER BY id DESC
limit 1;
the query above works but I have an event related issue. T1 triggers to T2 and I can't place this on T2 (as a new trigger) it conflicts with the T1 trigger and throws an error (not sure why). Any thoughts on where else it could go as a process related to passing the MaxOffldDRCClientID back to T1 after T2 record insert (I have tried both before and after insert and they both throw the same error saying it conflicts with the T1 trigger)