漏洞
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.
| 漏洞 ID 编号 | NIM001741 |
|---|---|
| 已提交 | March 28, 2006 |
| 上次修改时间 | June 5, 2024 |
| 适用范围 | No Product Found |
| 找到的版本 | 9.2 |
| 状态 | Duplicate |
附加信息
NIM004401解决办法
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>重现步骤
漏洞 ID: NIM001741
软件:
- No Product Found
当漏洞状态发生变化时获得通知
发现关于本主题的更多内容
搜索相关信息
查找与此主题相关的培训
探索想法并提供反馈
获取来自 ArcGIS 专家的帮助
下载 Esri 支持应用程序