Skip to content

Latest commit

 

History

History
55 lines (38 loc) · 1.96 KB

setfetchdirection-method-sqlserverresultset.md

File metadata and controls

55 lines (38 loc) · 1.96 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic apilocation apiname apitype
setFetchDirection Method (SQLServerResultSet)
setFetchDirection Method (SQLServerResultSet)
David-Engel
v-davidengel
01/19/2017
sql
connectivity
reference
sqljdbc.jar
SQLServerResultSet.setFetchDirection
Assembly

setFetchDirection Method (SQLServerResultSet)

[!INCLUDEDriver_JDBC_Download]

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 [!INCLUDEjdbcNoVersion]. If you use this method, the JDBC driver remembers the setting, but currently does not act on it.

Syntax

  
public void setFetchDirection(int direction)  

Parameters

direction

An int 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

SQLServerResultSet Members
SQLServerResultSet Class