0

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

Ove Halseth
  • 431
  • 5
  • 13

0 Answers0