Numéro de bogue NIM012414
Envoyé Oct 17, 2007
Modified Jun 11, 2020
Gravité Low
S’applique à ArcGIS for Desktop
Version trouvée No Version Found
Langage de programmation N/D
Plateforme serveur
Plateforme client
Base de données All
Paramètre régional N/D
Statut Not in Current Product Plan
Version corrigée
Résolu par le fournisseur

Bogue NIM012414


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

Informations supplémentaires

No Public Explanation

Autre solution

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.