Thank you all.
After much putzing with the various parts involved it is beginning to
look like my original plan of having an email message sent when someone
adds a new record to this file is not to be. Apparently executing an
"SH" verb in a trigger program is not going to happen (Verb "SH" illegal
when a transaction is active.). Boom Splat.
Henry Unger wrote:
Lock the record before you write it.
Henry Unger
Sent from my iPad
On Jul 30, 2010, at 2:47 PM, "Jeff Schasny" <jscha...@gmail.com> wrote:
So far so good. Trigger installed. Trigger blows up. My trigger program calls the
*MAIL.SEND routine (which works when called from other programs in this account) which
is apparently blowing up when attempting to write an item to the current directory
(&UFD&) at line 214.
Anyone have a guess on what this means?
Program "*MAIL.SEND": Line 214, FATAL: The locks necessary for database
operations at the current isolation level (0) are not held by this process.
Error performing trigger for "/upg/CUBUPG/CO.TF"
--
------------------------------------------------------------------------
Jeff Schasny - Denver, Co, USA
jschasny at gmail dot com
------------------------------------------------------------------------
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
--
------------------------------------------------------------------------
Jeff Schasny - Denver, Co, USA
jschasny at gmail dot com
------------------------------------------------------------------------
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users