:: com :: sun :: star :: sdbc ::

interface XMultipleResults
Description
is used for inspecting multiple results produced by the execution of a SQL statement.

Under some (uncommon) situations a single SQL statement may return multiple result sets and/or update counts. Normally you can ignore this unless you are (1) executing a stored procedure that you know may return multiple results or (2) you are dynamically executing an unknown SQL string. The methods ::com::sun::star::sdbc::XMultipleResults::getMoreResults() , ::com::sun::star::sdbc::XMultipleResults::getResultSet() and ::com::sun::star::sdbc::XMultipleResults::getUpdateCount() let you navigate through multiple results.

See also
::com::sun::star::sdbc::XStatement, ::com::sun::star::sdbc::XPreparedStatement

Methods' Summary
getResultSet returns the current result as a ::com::sun::star::sdbc::ResultSet object. This method should be called only once per result.  
getUpdateCount returns the current result as an update count.  
getMoreResults moves to a Statement's next result. It returns true if this result is a ResultSet. This method also implicitly closes any current ResultSet obtained with getResultSet.  
Methods' Details
getResultSet
::com::sun::star::sdbc::XResultSet
getResultSet()
raises( ::com::sun::star::sdbc::SQLException );

Description
returns the current result as a ::com::sun::star::sdbc::ResultSet object. This method should be called only once per result.
Returns
the ResultSet object
Throws
SQLException if a database access error occurs.
getUpdateCount
long
getUpdateCount()
raises( ::com::sun::star::sdbc::SQLException );

Description
returns the current result as an update count.

If the result is a ResultSet or there are no more results, -1 is returned. This method should be called only once per result.

Returns
the current result as an update count.
Throws
SQLException if a database access error occurs.
getMoreResults
boolean
getMoreResults()
raises( ::com::sun::star::sdbc::SQLException );

Description
moves to a Statement's next result. It returns true if this result is a ResultSet. This method also implicitly closes any current ResultSet obtained with getResultSet.

There are no more results when (!getMoreResults() && getUpdateCount() == -1) .

Returns
true if there exists more ResultSet objects
Throws
SQLException if a database access error occurs.
Top of Page