Universe triggers start an implicit transaction. As a transaction requires that is is recoverable, then by default Universe does not allow the execution of certain verbs within a transaction. You get around that by putting an H into field of the VOC entry as suggested.
> -----Original Message----- > From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- > us...@listserver.u2ug.org] On Behalf Of Ken Ford > Sent: Thursday, 16 April 2009 2:52 p.m. > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] DATE.FORMAT illegal when a transaction is active > > Thank you to those who assisted with this issue. Adding 'H' to the > DATE.FORMAT verb did the trick. However, it is not apparent why it > did! > Perhaps Universe thinks it is running a transaction when a file trigger > subroutine executes. No transaction was active. > > Regards, > > Ken Ford > > Universe Software Developer > > [cid:image001.gif@01C9BE8F.CF28AD00]<http://www.firstmac.com.au/> > > Phone: > > (07) 3013 8686 > > Email: > > ken.f...@firstmac.com.au<mailto:mark.b...@firstmac.com.au> > > Web: > > www.firstmac.com.au<http://www.firstmac.com.au/> > > > > > ####################################################################### > ###### > ######## > This email (inc all attachments) is for the use of the intended > recipient(s) > only. > Privileged or confidential information may be contained in this > communication. > If you have received this email in error, please notify the sender > immediately > and then > delete all copies of this message from your computer network. If you > are not > the > intended recipient, you must not keep, use, disclose, copy or > distribute this > email > without the author's prior permission. If you are the intended > recipient and > you do > not wish to receive similar electronic messages from us in future, then > please > respond to the sender to this effect. > > We have taken precautions to minimise the risk of transmitting software > viruses, but > advise you to carry out your own virus checks on this email and its > attachments. We > do not accept liability for any loss or damage caused by software > viruses and > do not > represent that this transmission is free from viruses or other defects. > > FirstMac Limited (ABN 59 094 145 963) (AFSL 290600) > ####################################################################### > ###### > ######## > > [demime 1.01d removed an attachment of type image/gif which had a name > of image001.gif] > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/