When/if you upgrade to UV 11.1 - perhaps you should use Index-based triggers - now supported by Rocket. Simpler than SQL-style triggers... see the new features.pdf in UV 11.1. Excerpt:
"In some circumstances, an application may not require all of the capabilities available to conventional triggers. In these cases, index-based subroutines may serve the purpose better because they have reduced overhead, which may translate to better performance." -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Chanco Sent: Friday, 1 April 2011 3:19 AM To: U2 Users List Subject: Re: [U2] Trigger questions While it's working I am getting back: [error] SQL update failed > good But I am also seeing Error performing trigger for customer > but It works the record is not updated Write failure > good Any idea on why I am getting the error performing trigger when it's obvious it's working? Thanks Dougc ************** IMPORTANT MESSAGE ***************************** This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ************************************************************** _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users