Re: Timestamp when a record is updated...

["Joe Teff" <jteff19@xxxxxxx>]

> I have never written a trigger, but I do have a question concerning the
> possibility of looping...
> If you have a file with a trigger.  And you update the file, the trigger
is
> then activated, but if your trigger updates the same file, does it re-call
> the trigger, and start a looping process....

The system always passes you the before and after pictures of the
record buffer. You would then make any necessary changes to the
"after" record. This is returned to the database manager and your
update is actually part of the original update. If you actually tried to
do the update in your trigger, then you could cause recursion. My
triggers always check for specific fields that change and skip any
processing unless required.

Joe Teff

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---