RE: Trigger Gotcha & Question

We had the same issue with not being able to turn off a trigger, so now
our trigger programs check a data area specific to the trigger whenever
they start.  If the data area is set to No, the program does an
immediate Return.  That way, even though the trigger is still executing,
it does not do anything.  We did this after finding (in the middle of
the day) a trigger in production had a bug, and having no way to
exclusively lock the file until late at night.

Fred Gamache
fgamache@gic.gi.com

>-----Original Message-----
>From:  Bob Larkin [SMTP:blarkin@wt.net]
>Sent:  Saturday, June 07, 1997 10:37 AM
>To:    MIDRANGE-L@midrange.com
>Subject:       Trigger Gotcha & Question
>
>First, the gotcha, MAKE SURE THE TRIGGER WORKS PERFECTLY BEFORE PUTTING
>IT IN PRODUCTION!!!!! Reason - besides whatever problems the program
>mmight have, as soon as the file is opened Update, the Trigger program
>is LOCKED. You cannot replace the program until all instances of the
>file file are closewd, so that the lock is released.
>
>
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *