Re: Trigger question

I don't really understand the question....

But it would seem to me, if the 2nd master file is
1) always updated when the first is
2) always updated after the first is

Then the 2nd master file would be a better place to have just a single trigger.

But even if the _ALWAYS_ above is true today, it might not be true tomorrow.

Consider having triggers on both files.

In particular, you may want to consider using the same program as a
trigger on both. You could then code the trigger such that it has to
be fired twice, once for each file before it does anything....


HTH,
Charles


On Wed, Jan 14, 2009 at 9:55 AM, John Furniss
<JFurniss@xxxxxxxxxxxxxxxxx> wrote:

List,

I am attaching a trigger program to one of two Mapics item
master files. I have it attached as 'After' and it works fine for the
first master file. The problem is that the record for the second item
master file has not yet been written when the trigger fires, so I can't
do any updates to it.

Do I need to attach a trigger to the second master file - or
is this question better for the Mapics list?



TIA,





John Furniss

Applications Programmer

Allied Machine & Engineering, Corp

Phone: 330-343-4283, ext. 8371

email: jfurniss@xxxxxxxxxxxxxxxxx



--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.