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 0

Karen

 
> 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?
> 
> 
> 

Reply via email to