Re: Trigger question

["Charles Wilt" <charles.wilt@xxxxxxxxx>]

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.