Icon MoveBy Method

function MoveBy(Value: Integer): Integer

Usage

Available In: Client and Server Applications

Use this method to move N number of rows forward or backward relative to the active row in the dataset, taking into account any active sort on the dataset. If the number of rows passed as the parameter to this method is negative, then the row pointer is moved backward in the dataset. If the number of rows is positive, then the row pointer is moved forward in the dataset.

If the row pointer cannot be moved the specified number of rows without proceeding past the first or last rows in the dataset, then the row pointer will be positioned at the first or last row in the dataset, setting the BOF and/or EOF properties as required.
Image