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.

See also

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