Bug-Nummer NIM012414
Erzeugt am Oct 17, 2007
Modified Jun 11, 2020
Schweregrad Low
Übernehmen für ArcGIS for Desktop
Gefundene Version No Version Found
Progr.-Sprache n. z.
Datenbank All
Gebietsschema n. z.
Status Not in Current Product Plan
Behoben in Version
SP Fixed

Bug NIM012414


Select query based on date field fails when joining a database table to a feature layer or coverage.

Zusätzliche Informationen

No Public Explanation

Alternative Lösung

Exported the joined attribute table as a standalone dbf table and store it in local drive will work with problem.

*Append the query on the joined table to include a statement for a target table field, (the example that follows uses fake table and field names) : jointable.joinfield = date '2002-05-20' AND targettable.targetfield IS NOT NULL

*If data are stored in enterprise databases, create a spatial view to join the table and the feature class. Then perform Select query on the spatial view.