RE: trigger advice needed

At 08:13 10/26/1998 , Brad Stone wrote:
>You might want to switch the trigger to perform *AFTER the update.
>There are two views of the record, one for before and one for after
>available in the trigger program.
>
>Instead of updating the file using the UPDATE opcode, I think you simply
>upddate the buffers of the After image and this will update the records.

It's the other way around. You update the after image in the before update 
trigger. The trigger definition must allow repetitive changes (ADDPFTRG 
command), and you must be running V3R2 or later OS. I think he'll still have a 
recursion problem though since he needs to update other records in the same 
file, and that will invoke the trigger again.



Pete Hall
peteh@inwave.com 
http://www.inwave.com/~peteh/

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---