Bug
In ArcMap, unable to perform string functions in definition queries after creating a join.
| Bug ID Number | NIM034140 |
|---|---|
| Submitted | April 10, 2008 |
| Last Modified | April 2, 2025 |
| Applies to | No Product Found |
| Version found | 9.2 |
| Status | Will Not Be Addressed |
Additional Information
No Public ExplanationWorkaround
1. If the user wants all rows for which PERIMETER is between 1400 and 1499. An alternative would be to use the >= and <= predicates and skip all the implicit conversions from numeric to string and back again as well as and the dbms specific funtions by using the standard sql: PERIMETER >= 1400 AND PERIMETER <= 1499.For more info please refer to the ArcGIS Help topic entitled "SQL Reference".2. Export the join to a feature class, and then perform the query.Steps to Reproduce
Bug ID: NIM034140
Software:
- No Product Found
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