Update: After further research and testing it seems to occur when there are character fields on the form that are larger than 255 characters. When I change the field length to 255 or less the columns reappear in the Sort/Levels tab. I was able to reproduce this using ARS 7.0 Patch 1 as well as Patch 2.
Workaround: Delete the character fields that are larger than 255 characters. Save. Add new characters fields (with the same IDs if workflow is attached) with the previous lengths. Changing the length of the fields to 255, then saving, then changing it back didn't fix it. Note: I have only tested this on display-only forms. For regular forms or any form with data you would need to first store the contents of the character fields (> 255) in other new fields before deleting the problem fields. I have reported this as a bug to our support vendor. Stephen -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Thursday, September 28, 2006 9:55 AM To: [email protected] Subject: ARS 7.0 Patch 2 Table Fields Sort Bug ARS 7.0 p2 Windows Server 2003 SQL Server 2005 I think I found a bug with Table fields in ARS 7.0 Patch 2. It works on another computer with Patch 1. On the Sort/Levels tab of a table's Field Properties window not all columns are visible/available...only on Display Only forms. On Regular forms all columns [in the source form] 255 characters or less are visible, as they should. I even tried copying a table field originally created on a Regular form to a Display Only form. Most of the sort columns are no longer visible on the DO form. I tried List View and Tree View display types. Has anyone else experienced this? Stephen ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
