laptop and a wrench

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.

Last Published: August 25, 2014 No Product Found
Bug ID Number NIM001741
SubmittedMarch 28, 2006
Last ModifiedJune 5, 2024
Applies toNo Product Found
Version found9.2
StatusDuplicate

Additional Information

NIM004401

Workaround

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>

Steps to Reproduce

Bug ID: NIM001741

Software:

  • No Product Found

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options