Unique Rows Property

ADO and SQL Server

ADO and SQL Server

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.