RE: Triggering between the same file in different Libraries

[Joe Giusto <JGiusto@xxxxxxxxxxxx>]

Can a trigger program determine which program updated the file that caused
the trigger program to start?  If so, and it was the other trigger program,
return.

Joe Giusto II
Patuxent Publishing Company
 <mailto:jgiusto@patuxent.com> mailto:JGiusto@patuxent.com
http://www.lifegoeson.com <http://lifegoeson.com> 


        -----Original Message-----
        From:   Kris Vaidyanathan [SMTP:krishnan@ozemail.com.au]
        Sent:   Tuesday, November 17, 1998 9:35 AM
        To:     MIDRANGE-L@midrange.com
        Subject:        Triggering between the same file in different
Libraries

        Hi,
                As part of the Y2k testing that we are ayttempting, we need
both 6 digit
        date versions and 8 digit date versions of the file to be kept in
sync.
                However we end up with the triggert program locking itself
out.
                FileA(6 digit version) has a record written to it, so *AFTER
*INSERT
        trigger program goes off and updates FILEA(8 digit version) which
triggers
        an update on FILEA(6 digit version). We have code to check the
record being
        updated and drop out of the loop. But, the second jump back to
FILEA(6 digit
        version) finds the record locked, since the intial trigger has not
        completed.

                We've come up with a way to get around this, clumsily.

                Anyone got any good ideas?
        krisV

        krishnan@ozemail.com.au


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