Skip Deleted Bookmarks Property

ADO and SQL Server

ADO and SQL Server

Skip Deleted Bookmarks Property

The Skip Deleted Bookmarks property indicates whether the recordset allows certain methods of the RecordSet object to skip a bookmark row and continue with the next row.

Applies To
Command Object Recordset Object
Syntax

object.Properties("Skip Deleted Bookmarks") [= value]

Parts

object

Expression that evaluates to an object in the Applies To list.

value

Boolean that indicates whether the called method skips the bookmark row, as specified in Settings.

Settings
Value Description
True The called method skips the bookmark row and continues with the next row.
False The called method returns DB_E_BADBOOKMARK.

Data Type

adBoolean

Modifiable

Read/write

OLE DB Property

DBPROP_BOOKMARKSKIPPED

Remarks

The Skip Deleted Bookmarks property has impact if a bookmark row has been deleted, if a recordset contains a bookmarked row to which the user does not have access rights, a bookmark identifying a row not in the chapter, or contains a bookmarked row that is no longer a member of the recordset.

These methods are affected:

  • GetRows Method

  • Move Method

  • MoveFirst Method

  • MoveLast Method

  • MoveNext Method

  • MovePrevious Method