Select query based on date field fails when joining a database table to a feature layer or coverage.
上次发布: November 30, 2015No Product Found
漏洞 ID 编号
NIM012414
已提交
October 17, 2007
上次修改时间
April 28, 2025
适用范围
No Product Found
找到的版本
9.2
状态
Known Limit
经开发团队审核,已确定此问题与不受 Esri 控制的软件的已知限制有关。 问题的“其他信息”部分可能包含进一步说明。
附加信息
No Public Explanation
解决办法
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.