Looks like in previous versions you could use @@nestlevel, but in ver 12 it always returns -1.
So how do you avoid update loops?
I'm trying to sync multiple connected contacts in the same table.
ALTER TRIGGER "Sync" AFTER UPDATE
ORDER 1 ON "Contact"
REFERENCING OLD AS oldRec NEW AS newRec
FOR EACH ROW
BEGIN
IF @@nestlevel = 1 THEN
UPDATE Contact set Title = newRec.Title
WHERE newRec.syncid = Contact.syncid;
END IF
END
This results