Triggers...

["Hillier, Martin" <Martin.Hillier@xxxxxxxxxx>]

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