writeseq supports an ON ERROR clause and you can check STATUS() AFTER THAT
> Subject: [U2] [UV] Checking file mode for type 19 item > Date: Thu, 3 Jul 2008 13:07:53 +1000 > From: [EMAIL PROTECTED] > To: [email protected] > > I need to check the write status of an item in a type 19 file. Normally, > it will bomb out on write while trying to update a read-only item. (on > error and else clauses don't seem to do much for this in a write > statement). > I have a 'before update' trigger checks if an item in a type 19 file is > writable. The only mechanism I can see is to use an 'openseq' on the > item and find 'status<5>' for it. > This works but it still seems a clumsy long way around. Does anyone know > a more efficient way to do this? > > Cheers, > Stuart Boydell > Senior Analyst > Information Services > Spotless > T +61 3 9269 7398 > M +61 4 1115 0246 > [EMAIL PROTECTED] > www.spotless.com > > > > ********************************************************************** > This email message and any files transmitted with it are confidential and > intended solely for the use of addressed recipient(s). If you have received > this communication in error, please reply to this e-mail to notify the sender > of its incorrect delivery and then delete it and your reply. It is your > responsibility to check this email and any attachments for viruses and defects > before opening or sending them on. Spotless collects information about you to > provide and market our services. For information about use, disclosure and > access, see our privacy policy at http://www.spotless.com.au > Please consider our environment before printing this email. > ********************************************************************** > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ _________________________________________________________________ Enter the Zune-A-Day Giveaway for your chance to win day after day after day http://www.windowslive-hotmail.com/ZuneADay/?locale=en-US&ocid=TXT_TAGLM_Mobi le_Zune_V1 ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
