Bogue
Query Builder does not build the proper date query when the layer has a join and all records are kept. Also, manually writing the expected SQL query for dates when joins are present doesnt work. This issue only effects Personal Geodatabases.
| Numéro d’ID de bogue | NIM001741 |
|---|---|
| Envoi | March 28, 2006 |
| Dernière modification | June 5, 2024 |
| S’applique à | No Product Found |
| Version trouvée | 9.2 |
| Statut | Duplicate |
Informations supplémentaires
NIM004401Solution de contournement
Use FGDB - there are no problems with above queries when using FGDB. If you must use PGDB, modify the query to be the following:FC1.date = date '01/12/2001' and Table1.OBJECTID > 0This is documented in the help: <a href="http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?id=257&pid=247&topicname=SQL_reference" target="_blank">http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?id=257&pid=247&topicname=SQL_reference</a>It is also documented in KB22132:<a href="http://support.esri.com/index.cfm?fa=knowledgebase.techArticles.articleShow&d=22132" target="_blank">http://support.esri.com/index.cfm?fa=knowledgebase.techArticles.articleShow&d=22132</a>Étapes pour reproduire
ID de bogue: NIM001741
Logiciel:
- No Product Found
Recevoir une notification lorsque le statut d’un bogue change
En savoir plus sur ce sujet
Rechercher des informations associées
Rechercher une formation sur ce sujet
Explorer des pistes et donner un avis
Obtenir de l’aide auprès des experts ArcGIS
Télécharger l’application Esri Support