NIM060478 for ArcGIS for Desktop

Bug ID Number	NIM060478
Submitted	August 24, 2010
Last Modified	April 2, 2025
Applies to	ArcGIS for Desktop
Version found	9.3.1
Status	Will Not Be Addressed

Additional Information

PLTS 9.3.1 Foundation has been retired.

Workaround

User can use either one of the following two suggested workarounds:A) Update Query as UPPER(Field Name) = Field Value, this will make the query NON-CASESENSITIVE.B) Follow the following steps :STEP - 1: Start an edit session.STEP - 2: Open the attribute table of each feature class and annotation layers that have a definition query.STEP - 3: Select MAPID_TXT field. Right click and select Field Calculator.STEP - 4: Field Calculator dialog appears. Select MAPID_TXT field under Fields:STEP - 5: Check the "Advanced" checkbox.STEP - 6: Enter MAPID_TXT = UCase([MAPID_TXT]). < See the attached screenshot >. Kindly note that values of all the fields with "TEXT" as field Type and taking part in the definition query need to be converted to "UPPERCASE".STEP - 7: Click Ok.STEP - 8: The field values of MAPID_TXT gets converted to Upper Case.STEP - 9: Close Attribute table.STEP - 10: Right Click feature classes and Annotation layers in Table of Contents and click Properties. Layer Properties dialog opens.STEP - 11: Change ISVISIBLE = 1 AND MAPID_TXT = 'Aena::ProductosAIS::EnRoute::BC_ENR_6_1_2::Mapa_General' TO MAPID_TXT = 'AENA::PRODUCTOSAIS::ENROUTE::BC_ENR_6_1_2::MAPA_GENERAL' STEP - 12: Now click the "Show Only Hidden Feature" button. Only those features should show up whose "IsVisisble" field value is set to "No".STEP - 13: Click "Show All Features" button. All the features should show up.STEP 14: Click "Show only Visible Features" button. Only those features should show up whose "IsVisisble" field value is set to "Yes".