After you have checked the Form -> Current View -> Fields in View and if you do not find this field even here, then for some reason you must be possibly having a reference of this field in the meta table Fields in the database...
Select fieldid, fieldname from fields where fieldname = '<whatever the Remedy database name of that field is>' and schemaid = <whatever the schemaid is>; If you find a row here, then as a double measure check that form again to see if you see a field on that form with that field ID.. what I usually do is when I open the form, I add all the fields those which are not in view too, to the view, they all accumulate to the top left corner, and then check the Field ID and/or the Field Name list to look for the field I am interested in. Do not save the form after adding all the fields to the view.. If you confirm its not on the form, then you delete the row you have found using the above select statement.. delete from fields where fieldname = '<whatever the Remedy database name of that field is> and schemaid = <whatever the schemaid is>; commit; Cheers Joe PS: commit is run after updates to a database on Oracle.. most other databases use auto commits.. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Rune Sorlid Sent: Wednesday, February 27, 2008 10:44 AM To: [email protected] Subject: Re: Deleting Fields, yet the don't delete ** Hi. Check out the Form-Current View-Fields in View... Se if you find the field in the list on the left... /Rune 2008/2/27, Lyons, Michael (USAEO) <[EMAIL PROTECTED]>: ** Windows 2003 Server SP1 SQL 2005 SP1 ARS 7.10 I have had an issue deleting fields and when I recreate them using the same labels and database names I receive the message "Field (XXXX) has a duplicate name. Please select a unique name for this field before saving the form. All other changes are not saved" The field names do not show in the Find Field List. My question: How do I remove these fields to reuse the database names. Fat and fast fingers created the problem. Michael F. Lyons Remedy Database Administrator No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.21.1/1301 - Release Date: 2/27/2008 8:35 AM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
