Knowledge Base - Technical Articles
HowTo: Enable Select by Attribute on an OLE DB table
| Article ID: | 20463 |
|---|---|
| Software: | ArcGIS - ArcEditor 8.1.2, 8.2, 8.3, 9.0, 9.1, 9.2, 9.3, 9.3.1, 10 ArcGIS - ArcInfo 8.1.2, 8.2, 8.3, 9.0, 9.1, 9.2, 9.3, 9.3.1, 10 ArcGIS - ArcView 8.1.2, 8.2, 8.3, 9.0, 9.1, 9.2, 9.3, 9.3.1, 10 |
| Platforms: | Windows NT 4.0, 2000, XP |
Summary
An OLE DB table that has a unique, not null, indexed field can support selections. This field can be used as a pseudo ObjectID field. In addition, any OLE DB table that has such an index will be able to participate fully in a relate operation; for example, with a spatial data set. Selection sets identified in the spatial data set may then be propagated to the related OLE DB table.
If the OLE DB table does not have a suitable field and you wish to enable Select by Attribute/relate the table to other data sources, add a new field.
If the OLE DB table does not have a suitable field and you wish to enable Select by Attribute/relate the table to other data sources, add a new field.
Procedure
Add a long integer field to the table and create a unique, not null index for it.
Populate the field with integer values, making sure all values are unique and no fields are empty.
If the OLE DB table's data source is an Access table, the primary key field must be of data type AutoNumber for the field to be recognized as a pseudo ObjectID. An index is not required. Created: 9/7/2001
Last Modified: 6/8/2011
Article Rating:
(2)
(2)
Comments
By Anonymous - 07/12/2004 3:00 PM
I had to debug this behavior today, and found that the Access AutoNumber field did not have to be indexed to work - just unique.
Rating:
By Anonymous - 02/05/2003 6:06 PM
This does not work for views.
By Anonymous - 09/23/2009 6:05 PM
The article needs to be updated.
pls update for current software versions...
Rating:
