Are you sure you are getting rid of it on ALL views in the form? Before you go to re-create it check the Fields in Views to make sure it does not still exist
Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Andreas Casey Sent: Tuesday, November 21, 2006 5:07 PM To: [email protected] Subject: The magic reappearing field... I'm trying to replace the Expected Resolution Field (ID 260000000) Character field on HPD:HelpDesk that was installed with ITSM 6. Platform is ARS 6.03 on Oracle 10g on W2K3. To give a little history this is an expansion server using customizations from a previously developed solution (great job Rob) which interestingly enough has this field installed as a Date/Time field. It seems more intuitive to me to have this field as a D/T, and obviously I want to maintain conformity across our solutions. I'm trying to replace the field with a corresponding D/T field with a matching field ID prior to importing the defs since I can't change the field type with an import. I'm successful at deleting it from HPD:HelpDesk after removing all the references on the associated join forms. After a database shutdown and restart the field does not exist on the form in ARAdmin and is not associated with HPD:HelpDesk in the Field table in Oracle. Here's where it gets a little weird. When I create an Expected Resolution Field Date/Time field with the same fieldID as the original character field I get an ARERR 407 Duplicate field/VUI ID in the definition. I then get an SQL Error The correct view was not created. Some fields were not saved. I close the form, reopen and voila! the field is there, only it's the Expected Resolution character field that I originally deleted. The references are also back in the Field table with a datatype of 4. If anybody has any ideas I'd appreciate them. Or maybe a good exorcism incantation.... _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
