$sql.resultSet.relative

Moves the cursor a relative number of rows, either positive or negative.
Syntax
    $sql.resultSet.relative{rows}
    $sql.resultSet{relative}{rows}
DocumentationMoves the cursor a relative number of rows, either positive or negative. Attempting to move beyond the first/last row in the result set positions the cursor before/ after the the first/last row. Calling relative(0) is valid, but does not change the cursor position.
Note: Calling the method relative(1) is identical to calling the method next() and calling the method relative(-1) is identical to calling the method previous().:

    Paramter:
      rows - an int specifying the number of rows to move from the current row; a positive number moves the cursor forward; a negative number moves the cursor backward
    Returns:
      1 if the cursor is on a row; 0 otherwise
    Throws:
      SQLException - if a database access error occurs, there is no current row, or the result set type is TYPE_FORWARD_ONLY
Examples
GroupSQL
Minimum required transaction-mode:NONE
Required scripting permission of the developerPERMISSION_FL_BASIC
Minimum parameters1
Maximum parameters 1