REPOSITION-FORWARD( ) method

Moves a query object’s result list pointer forward a particular number of rows.

Return type:

LOGICAL

Applies to:

Query object handle

 

Syntax 

REPOSITION-FORWARD ( n )

n

An integer expression representing the number of rows.

REPOSITION-FORWARD( ) always places the cursor between rows. For example:

If the cursor in on a row—say, row 5—REPOSITION-FORWARD(1) moves the cursor to row 6, then to half way between rows 6 and 7. From this position, GET-PREV( ) moves the cursor to row 6, while GET-NEXT( ) moves the cursor to row 7.

If the cursor is between two rows—say, between rows 5 and 6— REPOSITION-FORWARD(1) moves the cursor to half way between rows 6 and 7. From this position, GET-PREV( ) moves the cursor to row 6, while GET-NEXT( ) moves the cursor to row 7.

Note:

The REPOSITION-FORWARD method corresponds to the REPOSITION statement with the FORWARDS option.

See also:

REPOSITION statement, REPOSITION-TO-ROW( ) method, REPOSITION-TO-ROWID( ) method