Re: Database Trigger and Update problems

[Frank.Kolmann@xxxxxxxxxx]

I also need a solution to this issue.
At present when I get an 'invalid update' I force the
'after image' to be the 'before image' but the user
does not know the update was rejected.
I was thinking of sending an escape message to the
calling program via the message apis. Dont know if this
will work. Not got around to it yet.
I am trying to implement a way to get member level
security via a trigger program.

Frank Kolmann

>date: Thu, 3 Jun 2004 11:33:52 -0500
>from: rob@xxxxxxxxx
>subject: Re: Database Trigger and Update problems
>Scott,
>Then how does one get the program to signal an error to whatever process
>attempts the update be it your RPG application, UPDDTA, C/S application,
>etc?
>Rob Berendt
>--
>Group Dekko Services, LLC
>Dept 01.073
>PO Box 2000