RE: Data base triggers

[Scott Mildenberger <Smildenber@xxxxxxxxxxxx>]

This is possible, we have a lot of triggers that do at this.  You just
change the field in the after buffer in your trigger program.  When you add
the trigger to the file, the trigger time must be *before and the ALWREPCHG
must be *yes.

Scott Mildenberger

> -----Original Message-----
> From: Tom Tufankjian [SMTP:Tom_Tufankjian@hbltd.com]
> Sent: Monday, January 24, 2000 1:46 PM
> To:   RPG400-L@midrange.com
> Subject:      Data base triggers
> 
> 
> 
> 
> Is it possible to have a trigger program update the record whose update
> triggered it without having it re-trigger itself infinitly?
> 
> I know that's an awfully long sentence so I'll try to give an example.
> 1.  A record is updated in a file
> 2.  The update triggers a program
> 3.  The trigger program updates a timestamp field, for example.
> 
> Would step 3 cause the trigger program to execute again?
> 
> 
> 
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---