Gives a hint as to the direction in which the rows in this SQLServerResultSet object will be processed.

Note: This method is not currently supported by the Microsoft SQL Server 2005 JDBC Driver. If you use this method, the JDBC driver remembers the setting, but currently does not act on it.

public void setFetchDirection(int direction)

Parameters

direction

An integer that indicates the suggested fetch direction. Can be one of the following values:

ResultSet.FETCH_FORWARD

ResultSet.FETCH_REVERSE

ResultSet.FETCH_UNKNOWN

Exceptions

SQLServerException

Remarks

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

The initial value of this method is determined by the SQLServerStatement object that produced this SQLServerResultSet object. The fetch direction can be changed at any time.

Note: Using this method when the cursor type is forward-only has no effect.

See Also