Unique Rows Property
The Unique Rows property specifies whether each row is uniquely identified by its column values.
Applies To
| Recordset Object |
Syntax
object.Properties("Unique Rows") [= value]
Parts
object
Expression that evaluates to an object in the Applies To list.
value
Boolean that indicates whether each row is uniquely identified, as specified in Settings.
Settings
| Value | Description |
|---|---|
| True | Each row is uniquely identified by its column values. |
| False | Rows in the recordset may or may not be uniquely identified by their column values. |
Data Type
adBoolean
Modifiable
Read/write
OLE DB Property
DBPROP_UNIQUEROWS
Remarks
If the Unique Rows property is set to True when opening the recordset, the provider adds additional columns, if necessary, to ensure that each row is uniquely identified by its values. These additional columns appear at the end of the recordset; have a DBID of type DBKIND_GUID_PROPID, DBKIND_PGUID_PROPID, DBKIND_GUID_NAME, or DBKIND_PGUID_NAME; and the guid (or pguid) element is (or points to) DBCOL_SPECIALCOL. These columns typically are not displayed to the user but are used by components such as update services to uniquely identify a row.
The provider optionally may duplicate existing columns in the recordset to ensure that key columns are included.
If the Unique Rows property is set to True and the provider supports the optional OLE DB IColumnsRowset meta data column DBCOLUMN_KEYCOLUMN, the set of columns that uniquely identify the row have a value of True in the DBCOLUMN_KEYCOLUMN column returned by IColumnsRowset. This may be a subset of the columns in the row, or all of the columns if the provider cannot determine a proper subset that uniquely identifies the row.