dbnumrets

Calculates the number of returned parameter values generated by a stored procedure or a remote stored procedure.

Syntax

INT dbnumrets ( PDBPROCESS dbproc );

where

dbproc

Is the DBPROCESS structure that is the handle for a particular workstation/ SQL Server process. It contains all the information that DB-Library uses to manage communications and data between the workstation and SQL Server.

Returns

The number of parameter values associated with the most recently executed stored procedure.

Remarks

For more information about stored procedure return parameters, see "dbretdata."

The server returns stored procedure information (including any return status and parameter values) immediately after returning all normal results for that stored procedure. Process the normal results, and then call dbnumrets after dbresults returns NO_MORE_RPC_RESULTS (for all stored procedures in a batch except the last one) or NO_MORE_RESULTS (for a single stored procedure, or for the last stored procedure in a batch).

See Also

dbnextrow, dbresults, dbretdata, dbretlen, dbretname, dbrettype, dbrpcinit, dbrpcparam