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"