I think a variable is the ONLY way. Here's example code:
SET VAR trigger_executed INTEGER
IF trigger_executed = 1 THEN
CLEAR VAR trigger_executed
RETURN 0
ENDIF
... {body of trigger}
SET VAR trigger_executed INTEGER = 1
RETURN 0Karen > I guess my next question is, what is the best way to avoid an endless > loop when updating a row that has been updated. > > Obviously some kind of variable flag could be used, but is there a better > way? > > >

