Moves a query object's result list pointer back a particular number of rows.

Return type: LOGICAL

Applies to: Query object handle

Syntax

REPOSITION-BACKWARD ( n )
n
An integer expression representing the number of rows.

Notes

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

    • If the cursor in on a row—say, row 5—REPOSITION-BACKWARD(1) moves the cursor to row 4, then to half way between rows 4 and 5. From this position, GET-PREV( ) moves the cursor to row 4, while GET-NEXT( ) moves the cursor to row 5.
    • If the cursor is between two rows—say, between rows 5 and 6— REPOSITION-BACKWARD(1) moves the cursor to half way between rows 4 and 5. From this position, GET-PREV( ) moves the cursor to row 4, while GET-NEXT( ) moves the cursor to row 5.
  • The REPOSITION-BACKWARD method corresponds to the REPOSITION statement BACKWARDS 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.