RE: Triggers...

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
Hi John,
        My problem isnt with the recursive call (Yet!) , but that I cannot
seem to update any records in the trigger program apart from the one that
originally evoked the trigger.

If i do not specify Allow Repeated change(*YES) on the trigger, the trigger
program crashes with a record lock on the original record. With it on *YES,
the original record is updated. In both cases the key used to get the record
for update in the trigger program is different to that of the original
record.

Thanks,
        Martin


-----Original Message-----
From: John Taylor [mailto:jtaylor@rpg2java.com]
Sent: 28 February 2002 15:52
To: rpg400-l@midrange.com
Subject: Re: Triggers...


Martin,

I just went through this problem a couple of weeks ago. Wrap your trigger
program in a CLP, or compile it so that the PEP is a CLLE procedure, and it
will then work recursively.


John Taylor

----- Original Message -----
From: "Hillier, Martin" <Martin.Hillier@Mattel.com>
To: <rpg400-l@midrange.com>
Sent: Thursday, February 28, 2002 8:39 AM
Subject: Triggers...


> This message is in MIME format. Since your mail reader does not understand
> this format, some or all of this message may not be legible.
> --
> [ Picked text/plain from multipart/alternative ]
> Hi all,
> I am attempting to use a trigger on a file to update the same file
> (but a different record). All I can seem to update is the same record as
the
> one that initiated the trigger - looking at the key the trigger program is
> using, its different to the record it reads.
>
> I know "this trigger updating triggered file" may worry some of you :-),
but
> its pretty safe - it always writes a subtotal for raw data. If raw data
> update hasnt triggered it, it does nothing, so there is only 1 recursive
> call, which immediately bombs out because it is evoked from a subtotal.
>
> Cheers,
> Martin


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