Quick References
ADO
ASP
CSS2
HTML
JavaScript
Jet SQL
VBScript
WML
WMLScript
WSH
XHTML
XML DOM
XSLT
Features
Knowledge Base
Tutorials
Partners
ZVON.ORG
XML
Planet Source Code
VisualBuilder
Web Design
Your HTML Source
XML/XSLT Forums
ASPAlliance
Scripts
Programmers Heaven
Tek-Tips Forums
Developer Fusion
Code Project
Bookmark Property
Clone Method
Record Object
METHOD: Recordset::CompareBookmarks
CompareEnum =
recordsetobject.
CompareBookmarks
(Bookmark1, Bookmark2)
The
CompareBookmarks
method returns one of the
CompareEnum
constants that allows you to compare the relative row positions of two records based upon the values of their bookmarks. Note that you are comparing bookmarks, not the values contained in the fields of the records.
CompareEnum Constants
Constant
Value
Description
adCompareEqual
1
Bookmarks are equal
adCompareGreaterThan
2
First bookmark is after second bookmark
adCompareLessThan
0
First bookmark is before second bookmark
adCompareNotComparable
4
Bookmarks cannot be compared
adCompareNotEqual
3
Bookmarks are not equal or in order
You can only make this comparison if both records are in the same
Recordset
object. You cannot compare bookmarks from two different
Recordset
objects. However, you can compare bookmarks for records in the same
Recordset
that have undergone sorting or filtering.
Obviously, the provider must support bookmarks or you cannot use this method.
There are two mandatory parameters. Both are variants in type.
The
Bookmark1
is the bookmark of the first record.
The
Bookmark2
is the bookmark of the second record.
Code (VBScript):
If objRecordset.
CompareBookmarks
(Bookmark1, Bookmark2) = adCompareEqual Then
MsgBox "Bookmarks Are Equal", vbOK
Else
MsgBox "Bookmarks Are Not Equal", vbOK
End If
Copyright 1999-2005 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information
