Bug
The Find and Replace command in the attribute table returns the following error: "An Invalid SQL statement was used."
| Bug ID Number | BUG-000121846 |
|---|---|
| Submitted | April 19, 2019 |
| Last Modified | June 5, 2024 |
| Applies to | ArcGIS for Desktop |
| Version found | 10.6.1 |
| Operating System | Windows OS |
| Operating System Version | 10.0 |
| Status | Will Not Be Addressed |
Additional Information
We apologize that we were unable to address this issue within the current product support cycle. If the issue continues to affect your work in a supported release, please contact Technical Support. Note that ArcGIS 10.8.2 is the current release of ArcGIS Desktop and will enter Mature Support in March 2024 (https://support.esri.com/en-us/products/arcmap/life-cycle). There are no plans to release an ArcGIS Desktop 10.9, and we recommend that you migrate to ArcGIS Pro. See Migrate from ArcMap to ArcGIS Pro (https://www.esri.com/en-us/arcgis/products/arcgis-pro/resources/migrate) for more information.Workaround
1. Select the field from which the text is selected. 2. Click Table Options > Find and Replace. 3. Type '000240-011-023' in the Find what text box, and check the 'Search Only Selected Field(s)' check box.Steps to Reproduce
Bug ID: BUG-000121846
Software:
- ArcGIS for Desktop
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App