$sql.resultSet.next

Moves the cursor down one row from its current position.
Syntax
    $sql.resultSet.next{}
    $sql.resultSet{next}
DocumentationMoves the cursor down one row from its current position. A ResultSet cursor is initially positioned before the first row; the first call to the method next makes the first row the current row; the second call makes the second row the current row, and so on.
If an input stream is open for the current row, a call to the method next will implicitly close it. A ResultSet object's warning chain is cleared when a new row is read.:

    Paramter:
    Returns:
      1 if the new current row is valid; 0 if there are no more rows
    Throws:
      SQLException - if a database access error occurs
Examples
GroupSQL
Minimum required transaction-mode:NONE
Required scripting permission of the developerPERMISSION_FL_BASIC
Minimum parameters0
Maximum parameters 1