Ken, A trigger runs within a file update transaction (and while the record is locked). You can't have input within a transaction as it breaks the ACID guarantee (see Wikipedia). So, you can't have input (including raid/debug) within your trigger. You'll need to either output some print statements or develop a test harness to run the trigger program that emulates the trigger process, without invoking an actual trigger. Cheers, Stuart Boydell
-----Original Message----- 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 ##################################################################################### 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) ##################################################################################### _______________________________________________ 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
