Re: Default user ID in SQL table - trigger

True, but one would have to understand the mediator. If one assumes that
the mediator simply is there to prevent a lock and you try an escape in
your end program only to find out that the mediator went gung ho with
error trapping and does not pass the escape up you could be in trouble.

But understanding the mediator is not a bad idea.

Not sure that the mediator should be the one blasting the escape message.
Then again, judging by the recent posts, perhaps it's harder than I think
for most people to get sending an escape message.

And, yes, doing what you can to supply information or diagnostic messages
would really help. So instead of "CPF9898-Trigger failed" something in
there about what constraint or whatever failed would be nice. Makes me
wonder how that would behave in
write e newrec;
if %error(myfile);
Select %status;
When 01023; // Error in trigger before file operation
// Retrieve diag or info message from job
// and do something about it
EndSl;
EndIf;

Rob Berendt