|已提交||Oct 17, 2007|
|Modified||Jun 11, 2020|
|应用于||ArcGIS for Desktop|
|找到的版本||No Version Found|
|状态||Not in Current Product Plan|
Select query based on date field fails when joining a database table to a feature layer or coverage.
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.