I know it's a clob and that inserts and updates to a clob are handled differently, and I don't recall offhand the 'how to' but in the past I have cleared diaries and setting them to null with an update at SQL level. So that is another option.
Sorry I can't help with the 'how to' at the moment but a quick SQL help should get you there. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Longwing, LJ CTR MDA/IC Sent: Wednesday, January 23, 2013 11:05 AM To: [email protected] Subject: Re: Clearing a diary field Andy, Diary fields are designed specifically to prevent this activity. There are a few tools out there that will let you edit the diary field...but honestly, easiest method if you don't have one of those is to export the record with request id and diary to ARX file, perform whatever changes to your ARX file with a text editor, and then re-import, updating the existing record, this will update the diary to the contents of the ARX file. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Mayfield, Andy L. Sent: Wednesday, January 23, 2013 8:52 AM To: [email protected] Subject: Clearing a diary field ** What's the easiest way to clear the values from a diary field? Or is there a way to do this? It seems it cannot be done through a filter or escalation. Andy L. Mayfield Alabama Power Company Protection & Control Technician Staff Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1846 _ARSlist: "Where the Answers Are" and have been for 20 years_ ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
