Bug
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.
| Bug-ID-Nummer | NIM001741 |
|---|---|
| Eingereicht | March 28, 2006 |
| Zuletzt geändert | June 5, 2024 |
| Gilt für | No Product Found |
| Gefunden in Version | 9.2 |
| Status | Duplicate |
Zusätzliche Informationen
NIM004401Workaround
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>Schritte zur Reproduzierung
Bug-ID: NIM001741
Software:
- No Product Found
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