Skip to content

SQLNextResultSet - cSQLStatement

Switch to the next result set of a batch or stored procedure.

Type: Function
Return Data Type: Integer

Syntax

Function SQLNextResultSet Returns Integer

Call Example

Get SQLNextResultSet to IntegerVariable

Description

Switch to the next result set in a batch of statements or a stored procedure/function that returns multiple result sets. The function will return 0 if there are no more result sets, a non zero value otherwise.

See the StoredProcedureMSSQL.vw and StoredProcedureODBC.vw views in the Specializd Components sample workspace for samples of calling a stored procedure.

Return Value

The function will return 0 if there are no more result sets, a non zero value otherwise.