Can we get a resolution to this added to the better and better list? I have complained about this for years ;-)....
I assume the restriction is to disable INPUT statements in the trigger subroutine, although there may be cases when this might be useful ????, not to disable debugging of programs which access files with triggers on them. For a solution in order of preference but probably increasing difficulty to implement. a) It would be good to be able to debug the trigger code. b) It would be good if the debugger stepped over the trigger without user intervention at a minimum..... Cheers, Phil > -----Original Message----- > From: [email protected] [mailto:u2-users- > [email protected]] On Behalf Of Hona, David > Sent: Monday, 12 April 2010 1:45 p.m. > To: [email protected] > Subject: Re: [U2] Input is not permitted when a trigger is active > > Unfortunately, this is a 'feature' of UV/SQL Triggers. You will have to > disable the trigger first, if you wish to use RAID. There aren't any > means to avoid this. > > Regards, > David > > > -----Original Message----- > From: [email protected] [mailto:u2-users- > [email protected]] On Behalf Of Ken Ford > Sent: Monday, 12 April 2010 11:17 AM > To: [email protected] > Subject: [U2] Input is not permitted when a trigger is active > > U2-listers, > Can anyone shed light on the message in the subject line? I have > searched all over the place and tried quite a few things to prevent it > happening. I am running RAID on a program that updates a file that has > an update trigger on it. As soon as the program hits the WRITE > statement to the file in question, it crashes with the above message. > Any assistance would be appreciated. > > Ken Ford > Software Engineer - Universe > > Phone: > 07 3013 8605 > Fax: > 07 3002 8400 > Email: > [email protected] > Web: > www.firstmac.com.au > > ************** 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 > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
