Hi Carey, You are absolutely right. I deleted the pool first without deleting the attachment fields. I followed the steps that you mentioned and now everything seems to be fine.
Thanks so much your help but I can't help to wonder that if the base (for eg. attachment pool) is deleted then anything in connection with the base (for eg. Attachment fields) are not deleted? I really appreciate you and all the others also who have responded. Thanks. Warm Regards, Nisha Ramtri -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: 21 August 2007 23:02 To: arslist@ARSLIST.ORG 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" *********************************************************************************** The Royal Bank of Scotland plc. Registered in Scotland No 90312. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB. Authorised and regulated by the Financial Services Authority This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc does not accept responsibility for changes made to this message after it was sent. Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by The Royal Bank of Scotland plc in this regard and the recipient should carry out such virus and other checks as it considers appropriate. Visit our websites at: www.rbs.com www.rbs.com/gbm www.rbsgc.com *********************************************************************************** ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"