Bug
Using definition queries in a personal geodatabase containing a feature class and a table with a relationship class return the following error message, "The expression was verified successfully, but no records were returned."
| Bug ID Number | BUG-000102903 |
|---|---|
| Submitted | February 14, 2017 |
| Last Modified | June 5, 2024 |
| Applies to | ArcGIS for Desktop |
| Version found | 10.3.1 |
| Operating System | Windows OS |
| Operating System Version | 10.0 64 Bit |
| Status | Will Not Be Addressed |
Additional Information
The two sides of the provided equation do not exist in the table which means a False value is compared to a False value. This will return a true, and therefore valid statement. However, as the fields do not exist, no actual records will be returned. Therefore this error message is accurate.Workaround
1. Add the layer and the table to the Table Of Contents.2. Right-click the layer > Joins and Relates > Joins.3. Join the layer and the table based on the common field, and select 'Keep only matching records'.4. Right-click the joined layer > Data > Export Data.5. Export the layer as a new layer, so that all attributes are listed down (common workflow for joining one-to-many data).Steps to Reproduce
Bug ID: BUG-000102903
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