Please note, this is a STATIC archive of website www.w3schools.com from 05 May 2020, cach3.com does not collect or store any user information, there is no "phishing" involved.
THE WORLD'S LARGEST WEB DEVELOPER SITE

ADO CompareBookmarks Method


❮ Complete Recordset Object Reference

The CompareBookmarks method compares two bookmarks. This method returns a CompareEnum value that indicates the bookmark's relative row positions.

Note: The two bookmarks must be within the same Recordset, or within a Recordset and its clone.

Note: You can use this method only if the provider support bookmarks.

Syntax

result=objRecordset.CompareBookmarks(mark1,mark2)

Parameter Description
mark1 The bookmark of the first row
mark2 The bookmark of the second row

CompareEnum Values

Constant Value Description
adCompareLessThan 0 The first bookmark is before the second
adCompareEqual 1 The bookmarks are equal
adCompareGreaterThan 2 The first bookmark is after the second
adCompareNotEqual 3 The bookmarks are not equal
adCompareNotComparable 4 The bookmarks cannot be compared

❮ Complete Recordset Object Reference