How to avoid infinite loop in Triggers?

From: NNOOR <Nnoor_at_cris.com>
Date: 1997/11/19
Message-ID: <64v9ov$5lh@examiner.concentric.net>#1/1

Hi,

Problem:
How can I avoid infinite loop in a trigger?

Scenerio:
Doing an operation in a trigger which the trigger was called for in the first place results in the infinite loop. For example doing UPDATE in a (Before/After) ON UPDATE trigger....

Reason for Doing:
I want to maintain the audit log. That is, when a user deletes a record, its not deleted but marked as such. Similary when a record is changed, an older copy is maintained with deleted marker. And so on?

The Challange:
How to accomplish it in triggers with getting caught in the cyclic infinite loops?

Thanks for your help!

Regards,
Nasir (nnoor_at_cris.com) Received on Wed Nov 19 1997 - 00:00:00 CST