ADO and SQL Server
Bookmark Type Property
The Bookmark Type property indicates the bookmark type supported by the recordset.
Applies To
| Command Object | Recordset Object |
Syntax
object.Properties("Bookmark Type") [= value]
Parts
object
Expression that evaluates to an object in the Applies To list.
value
Integer specifying the bookmark type as specified in settings.
Settings
| Constant | Description |
|---|---|
| DBPROPVAL_BMK_NUMERIC | The bookmark type is numeric. Numeric bookmarks are based on a row property that is not dependent on the values in the columns of the row. For example, they can be based on the absolute position of the row within a recordset or on a row ID that the storage engine assigns to the row at its creation. The validity of numeric bookmarks is not changed by modifying the columns in a row. |
| DBPROPVAL_BMK_KEY | The bookmark type is key. Key bookmarks are based on the values of one or more of the columns in a row. These values form a unique key for each row. A key bookmark may be left dangling if the key values of the corresponding row are changed. |
Data Type
adInteger
Modifiable
Read/write
OLE DB Property
DBPROP_BOOKMARKTYPE