relative Method (SQLServerResultSet)

Article
11/18/2022

Moves the cursor the given amount of rows, relative to the current row, in either a positive or negative direction.

Syntax

  
public boolean relative(int nRows)

Parameters

nRows

An int that indicates the number of rows to move.

Return Value

true if the cursor is on a row. Otherwise, false.

Exceptions

SQLServerException

Remarks

This relative method is specified by the relative method in the java.sql.ResultSet interface.

Trying to move beyond the first or last row in the result set positions the cursor before or after the first or last row. Calling relative(0) is valid, but does not change the cursor position.

Calling the method relative(1) is identical to calling the next method. Calling the method relative(-1) is identical to calling the previous method.