Re: Trigger Problem

This application is a financing application that runs over a file from a
different application.  We were not permitted to change the initial
application.  We wrote this new application and are using the trigger to
initiate the action from the first application writing, updating, or
deleting a record in the file.  Sounds confusing, but..like you said..it is
Friday.  We do not need to worry about OPS Nav or a download.  All we need
to worry about is when the file is updated in a green screen interactive
session.


Mike

----- Original Message -----
From: <rob@dekko.com>
To: <RPG400-L@midrange.com>
Sent: Friday, May 25, 2001 4:34 PM
Subject: Re: Trigger Problem


>
> Sorry Mike for the jab - it's Friday.
>
> How do you write the screen out to the user if the trigger is activated by
> updating the database using Excel or Operations Navigator?
> Wouldn't you be better served by the trigger program initiating an error
> and the program which attempted the update trapping for the error?
>
> Rob Berendt
>
> ==================
> A smart person learns from their mistakes,
> but a wise person learns from OTHER peoples mistakes.
>
>
>
>                     "Mike Silvers"
>                     <msilvers@HBS-INC        To:
<RPG400-L@midrange.com>
>                     .COM>                    cc:
>                     Sent by:                 Subject:     Re: Trigger
Problem
>                     owner-rpg400-l@mi
>                     drange.com
>
>
>                     05/25/01 11:54 AM
>                     Please respond to
>                     RPG400-L
>
>
>
>
>
>
> Yea..the program has a lock on it.  The complicated part here is the
> program
> is interactive and responds with a screen to the user if the record does
> not
> meet specific criteria.  For this reason, I have to use a data area and
the
> program must be called.  By calling this program, it puts the rogram in
the
> job stream of the interactive user and the window can be displayed.
>
> Mike
>
> ----- Original Message -----
> From: "Jim Langston" <jimlangston@conexfreight.com>
> To: <RPG400-L@midrange.com>
> Sent: Friday, May 25, 2001 12:11 PM
> Subject: Re: Trigger Problem
>
>
> > The program itself has a lock on it?
> >
> > Strange, I don't think I've seen that happen before.  Lots of people
> > are calling the same programs on our system with no locking issues of
> > the program objects themselves.
> >
> > Of course it is possible there is some mechanism going on here that we
> > have just never used, so never ran into the locking issue.
> >
> > Are you sure the lock is on the program and not a file that the program
> > is opening?
> >
> > Regards,
> >
> > Jim Langston
> >
> > Me transmitte sursum, Caledoni!
> >
> > Buck Calabro wrote:
> > >
> > > Mike Silvers wrote:
> > >
> > > >If we turn off the data area so the program that does
> > > >the work is not called anymore, the lock still exists.
> > > >This is the problem.  Does anyone have any
> > > >suggestions on how to resolve the locking issue
> > > >(other than having the users sign off -- that is
> > > >not an option)?
> > >
> > > Add an option so that the "work" program can set LR on and free itself
> from
> > > storage.  Either have a third value in the data area, a separate data
> area,
> > > etc.  The point is to have a signal that the working program can read
> to
> > > terminate itself.
> > >
> > > Buck Calabro
> > > Commsoft; Albany, NY
> > > "Nothing is so firmly believed as
> > >  that which we least know" -- Michel Montaigne
> > > Visit the Midrange archives at http://www.midrange.com
> > +---
> > | 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
> > +---
>
> +---
> | 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
> +---
>
>
>
>
> +---
> | 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
> +---

+---
| 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
+---