Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Visual Basic: RDO Data Control

Visual Studio 6.0

Move Method (Remote Data)

See Also    Example    Applies To

Repositions the current row pointer in an rdoResultset object.

Syntax

object.Move rows[, start]

The Move method syntax has these parts:

Part Description
object An object expression that evaluates to an object in the Applies To list.
rows A signed Long value that specifies the number of rows the position will move as described in Settings.
start A Variant value that identifies a bookmark as described in Settings.

Settings

If rows is greater than 0, the position is moved forward (toward the end of the cursor). If rows is less than 0, the position is moved backward (toward the beginning of the cursor). If rows is equal to 0, any pending edits are discarded and the current row is refreshed from the data source. At a lower level, when you use 0 as the rows argument, RDO executes the ODBC SQLExtendedFetch function to re-fetch the current rowset (as determined by the RowsetSize property) from the database.

If start is specified, the move begins relative to this bookmark. If start is not specified, Move begins from the current row.

Remarks

If using Move repositions the current row to a position before the first row, the position is moved to the beginning-of-file (BOF) position. If the rdoResultset contains no rows and its BOF property is set to True, using this method to move backward triggers a trappable run-time error. If either the BOF or EOF property is True and you attempt to use the Move method without a valid bookmark, a trappable error is triggered.

If using Move repositions the current row to a position after the last row, the position is moved to the end-of-file (EOF) position. If the rdoResultset contains no rows and its EOF property is set to True, then using this method to move forward produces a trappable run-time error.

If you use Move on an rdoResultset object based on an SQL-specific query or rdoQuery, the query is forced to completion and the rdoResultset object is fully populated.

If you use any method that repositions the current row pointer after using the Edit or AddNew method but before using the Update method, any changes made to the copy buffer are lost.

To make the first, last, next, or previous row in an rdoResultset the current row, use the MoveFirst, MoveLast, MoveNext, or MovePrevious method. To position the current row pointer based on an absolute row number, use the AbsolutePosition property. To position the current row pointer based on a percentage of the accessed rows of a result set, use the PercentPosition property.

When you use the Move method or any other method to reposition the current row pointer, the RowCurrencyChange event is fired.

When using a forward-only rdoResultset, the you can reposition the current row only by using the MoveNext method. You cannot use the MoveLast, MovePrevious, MoveFirst, or Move method, or the PercentPosition or AbsolutePosition property, to reposition the current row pointer.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.