This method of the Recordset class compares two bookmarks and returns an indication of their relative values.
public int compareBookmarks(Object bookmark1, Object bookmark2);
Returns a AdoEnums.Compare value that indicates the relative row position of two records represented by their bookmarks.
bookmark1 | The bookmark of the first row. |
bookmark2 | The bookmark of the second row. |
The bookmarks must apply to the same Recordset object, or a Recordset object and its clone. You cannot reliably compare bookmarks from different Recordset objects, even if they were created from the same source or command. Nor can you compare bookmarks for a Recordset object whose underlying provider does not support comparisons.
A bookmark uniquely identifies a row in a Recordset object. Use the current row's Bookmark property to obtain its bookmark.
An invalid or incorrectly formed bookmark will cause an error.