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











PROPERTY:  Recordset::Bookmark
variant = recordsetobject.Bookmark
recordsetobject.Bookmark = variant

The Bookmark property sets or returns a variant that uniquely marks the current record. This allows you to quickly return to that record, even after you have visited numerous other records in the same Recordset. Note that the actual value of the bookmark is not important and, even if you try, you may not be able to view the value.

If you have created a copy of a Recordset using the Clone method, both the original and the clone will have the same bookmark.

Unfortunately, not all providers support the Bookmark property. In this regard, support is cursor dependent. For example, server-side dynamic cursors do not support bookmarks, while client-side and static cursor usually do provide support.

Code (VBScript):
varBookMark = rsChantList.Bookmark
rsChantList.MoveFirst
rsChantList.Find "ChantName = 'Oma' "
If (objRecordset.EOF = True) Then
   MsgBox "Record not found", vbOK
   rsChantList.Bookmark = varBookMark
End If

 


Copyright 1999-2005 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information