One would "Hope and Think" that the "Administrator tool is bullet proof", and by that I mean, since you must do EVERYTHING via this GUI Tool, you should not be able to shoot yourself in the foot.
For example, deletion of attachment pool from ALL views of a form AUTOMATICALLY cascades the deletion to the attachment fields. (deletion of the pool from a VIEW of the form should automatically remove the attachment fields from that VIEW) After all, an attachment field without the pool is useless. Simply watching this list over the years, has proven that "more and more" of these "features" are becoming permanent parts of the Admin Tool. I know that I certainly have tripped and fallen on the sword a few times myself... Whoops, sorry, forgot to turn on/off <RANT> Thanks-n-advance; HDT Platform Incident / Problem Manager & Architect Robert Molenda IT OS PA Tel: +1 408 503 2701 Fax: +1 408 503 2912 Mobile: +1 408 472 8097 [EMAIL PROTECTED] Quality begins with your actions. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Tuesday, August 21, 2007 10:32 AM To: [email protected] Subject: Re: Error in query..URGENT Nisha, It is a common mistake is to delete the attachment pool before the attachment fields. Are you sure you removed the attachment fields? Open the form in the Admin Tool and go to the Form (Menu) --> Current View (Menu) -->Fields in View (Menu Item) and verify that these fields do not appear in the "Fields Not in View: (By Name)" list. If the fields are there... then... Select the attachment field and click the "Add>>>" button. You will be prompted to either create a pool or pick an existing pool to relate the attachment field too. (Choose either path) ( repeat above if you have multiple attachment fields without an attachment pool) Then view the field properties for the select the Attachment pool you picked above. Go to the Attachment fields tab. Select the Attachment field and click the Delete button ( repeat above if you have multiple attachment fields without an attachment pool) Hope that helps. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On 8/21/07, RAMTRI, Nisha, IDC <[EMAIL PROTECTED]> wrote: > ** > > Hi List, > > I have a staging table in Remedy database (this is a regular form) and > through a simple stored procedure I'm trying to insert records into this > table. However, whenever I'm trying to insert a record I get the following > error: > > View 'RM_FaultSubmit' is not updatable because a field of the view is > derived or constant. > Msg: 4406, Level: 16, State: 1 > > Some days back I had made changes to this staging form. There was an > attachment pool created on this form with 2 attachment fields Attachment 1 > and Attachment 2. Now I have deleted the Attachment Pool from the staging > form and also deleted attachment fields (i.e. Attachment 1 and Attachment 2) > from 'Field' table. However on the form I continue to get reference of these > 2 fields. Is it because of this that I am now unable to insert/update the > table? > > I am really stuck because of this. We are on ARS 6.3 and Sybase 12.5 and Sun > OS 5.8. > > Thanks. > > Warm Regards, > > Nisha Ramtri ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
