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-Nummer | BUG-000102903 |
|---|---|
| Eingereicht | February 14, 2017 |
| Zuletzt geändert | June 5, 2024 |
| Gilt für | ArcGIS for Desktop |
| Gefunden in Version | 10.3.1 |
| Betriebssystem | Windows OS |
| Betriebssystemversion | 10.0 64 Bit |
| Status | Will Not Be Addressed |
Zusätzliche Informationen
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).Schritte zur Reproduzierung
Bug-ID: BUG-000102903
Software:
- ArcGIS for Desktop
Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert
Weitere Informationen zu diesem Thema erkunden
Nach zugehörigen Informationen suchen
Nach Schulungen zu diesem Thema suchen
Ideen erkunden und Feedback geben
Unterstützung durch ArcGIS-Experten anfordern
Esri Support App herunterladen