getMoreResults Method (int)

Article
11/18/2022

Moves to the next result of this SQLServerStatement object and deals with any currently open result set objects according to the instructions specified by the given mode.

Syntax

  
public final boolean getMoreResults(int mode)

Parameters

mode

An int that indicates how to handle currently open result set objects. Must be one of the following constants:

CLOSE_CURRENT_RESULT

KEEP_CURRENT_RESULT (not supported by the JDBC driver)

CLOSE_ALL_RESULTS

Return Value

true if the returned result is a result set. Otherwise, false.

Exceptions

SQLServerException

Remarks

This getMoreResults method is specified by the getMoreResults method in the java.sql.Statement interface.

If the getMoreResults method is called before results are retrieved, it behaves as specified by the mode argument and moves to the next result.

Note

The JDBC driver does not support using the KEEP_CURRENT_RESULT constant. If it is used, an exception will be thrown.