laptop and a wrench

Error

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."

Última publicación: August 8, 2017 ArcGIS for Desktop
Número de ID del error BUG-000102903
EnviadoFebruary 14, 2017
Última modificaciónJune 5, 2024
Relacionado conArcGIS for Desktop
Versión encontrada10.3.1
Sistema operativoWindows OS
Versión de sistema operativo10.0 64 Bit
EstadoWill Not Be Addressed

Información adicional

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.

Solución alternativa

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).

Pasos para reproducir

ID del error: BUG-000102903

Software:

  • ArcGIS for Desktop

Recibir notificaciones cuando cambie el estado de un error

Descargar la aplicación de soporte de Esri

Descubrir más sobre este tema

Obtener ayuda de expertos en ArcGIS

Contactar con el soporte técnico

Descargar la aplicación de soporte de Esri

Ir a opciones de descarga