Thanks, Fred. I exported the form and found a reference to "536870912" in the attachment field def. So I created an Attachment Pool with that field id. The attachment fields automatically appeared in the attachment list and I deleted them. When I tried to save the form it said that "536870912" was a duplicate ID, so I gave the pool a new id, saved the form, then reopened it and deleted the pool. Now the orphaned fields have gone on to their reward.
BTW, what I said in reply to Christie was all wrong. I thot I had saved the form, but I didn't. When you enter the name of an existing attachment field and try to save, it complains about a duplicate name. So you can't add existing attachment field to a new pool, at least as far a I can see. And yes, deleting an attachment field from the attachment list does delete the field itself. Thanks again, Dwayne ---- Original message ---- >Date: Thu, 15 Nov 2007 10:24:01 -0600 >From: "Grooms, Frederick W" <[EMAIL PROTECTED]> >Subject: Re: Deleting orphaned attachment fields >To: [email protected] > >If you want to know the ID of the old attachment pool, export the form >to a def file and view the def. The Attachment pool ID is listed in the >display-instance of the Attachment field. > >Fred > >-----Original Message----- >From: Action Request System discussion list(ARSList) >[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin >Sent: Thursday, November 15, 2007 9:59 AM >To: [email protected] >Subject: Deleting orphaned attachment fields > >Hello Everyone, > >I deleted an Attachment Pool without first deleting the attachment >fields. (I assumed it was like a page holder where deleting the holder >also deletes the pages.) Now the pool is gone, but the attachment >fields are still in my field list. If I knew the field-id of the >now-desceased pool I could recreate it, but I don't. I read the >"Attachment" section of the "Database Reference" but couldn't find the >info I was looking for. > >Any ideas? > >(ARS 7.1, RH Linux server, Oracle 10.2 db) > >Dwayne Martin >James Madison University > >_______________________________________________________________________________ >UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
