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.

Notes

  • 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.
  • The REPOSITION-FORWARD method corresponds to the REPOSITION statement with the FORWARDS option.
  • When you execute an OPEN QUERY or REPOSITION statement for a query associated with a browse widget, the browse is automatically adjusted to remain in sync with the query. However, when you execute a GET statement or method, the browse is not adjusted. You can use the GET statement, or one of the GET methods (GET-CURRENT/FIRST/LAST/NEXT/PREV) to perform background processing without affecting the browse, but you must execute a REPOSITION statement or one of the REPOSITION methods (REPOSITION-BACKWARD/FORWARD/TO-ROW/TO-ROWID) to put the query and browse back in sync.

See also

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