David,
I'd love to try it. The process of adding an "H" to the VOC pointer
didn't do the trick and that was pretty much my last gasp.
David A. Green wrote:
Jeff,
I've written a socket driven email subroutine. I haven't tried it from a
trigger but you don't have to shell out so it might work.
David A. Green
(480) 813-1725
DAG Consulting
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Jeff Schasny
Sent: Friday, July 30, 2010 12:47 PM
To: U2 Users List
Subject: Re: [U2] Universe Triggers
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" <[email protected]> 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
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
--
------------------------------------------------------------------------
Jeff Schasny - Denver, Co, USA
jschasny at gmail dot com
------------------------------------------------------------------------
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
