Re: Trigger Question

[Jim Langston <jimlangston@xxxxxxxxxxxxxxxx>]

Depends on your application.

It would be very easy to add a trigger program, get the user name,
and compare it against a list.  If it is a costing bill and the user
is not on the list... now what do you do?  In the trigger program you
can simply not write the record, but what about the program that
expected this record to be written?  Is it going to count on that for
further processing?

Or you could maybe cause a program error to percolate up, but is that
acceptable?

Like I said, it all depends on your application.

Regards,

Jim Langston

> Terri Harteau wrote:
> 
> Hi,
>     I have a bill of material file that has several bills for each item 
>number. One for manufacturing and one for costing. I need to restrict 
>maintenance of the costing bill to accounting users only. I would like to not 
>modify the packaged maintenance program. Would a trigger work for this? I 
>haven't used them before, I thought it might work based on other e-mails to 
>this list.
> 
> Terri Harteau
> tshaw@felkerbrothers.com
> Felker Brothers Corp.
> 
>------------------------------------------------------------------------------------------------------------------
> "Any sufficiently advanced technology is indistinguishable from magic."
> Arthur C. Clarke
> 
>------------------------------------------------------------------------------------------------------------------
+---
| 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
+---