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
MoveFirst Method
MoveLast Method
MoveNext Method
MovePrevious Method
METHOD: Recordset::Move
string =
recordsetobject.
Move
(NumRecords,
Start
)
The
Move
method is called to move the position of the current record pointer. As required, the current cache of records is automatically updated in concert with the move. If the current record has been modified and an
Update
has not been performed, then when you call
MoveFirst
, there will also be an implicit call to
Update
for the current record. If you do not wish to keep the changes to the current record, then you should call
CancelUpdate
before you call
MoveFirst
.
There is one mandatory parameter and one optional parameter.
The
NumRecords
parameter is a long value that specifies how many records the current record pointer will move. A value of zero does nothing.
A positive number moves the current record pointer forward. If a forward move would take you past the last record, then the pointer is set to
EOF
and the
EOF
property is set to
True
.
A negative number moves the current record pointer backwards. If a backward move would take you to before the first record, then the pointer is set to
BOF
and the
BOF
property is set to
True
.
If a
Recordset
is using a forward moving cursor, then you can only go backwards as far as the first record in the current cache of records. Therefore, how far you can move backwards will be determined by the
CacheSize
property. However, you can go forward to as far as the last record or
EOF
.
The optional
Start
parameter is a variant that is either a bookmark or one of the
BookmarkEnum
constants that indicates the starting position for the search. The default is to start at the current record.
BookmarkEnum Constants
Constant
Value
Description
adBookmarkCurrent
0
Default, start search at current record
adBookmarkFirst
1
Start search at first record
adBookmarkLast
2
Start search at last record
Code (VBScript):
varBkMrk = objRecordset.Bookmark
objRecorset.
Move
lngMoveNum
If objRecordset.EOF = True
objRecordset.Bookmark = varBkMrk
End If
Copyright 1999-2005 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information
