Thanks, I've got a demo running nicely, thanks to you and Emmitt. What is the 0 after your returns?
________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, January 13, 2010 4:22 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: date tracking question 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?
