TStoredProc.GetResults Method

Returns the output parameter values from a Sybase or MSSQL stored procedure.

Pascal

procedure GetResults;

C++

__fastcall GetResults();

Description

Call GetResults to force a Sybase or MSSQL stored procedure to return its result set, if any, to the client. For stored procedures on all other servers, result sets are automatically flushed to the client, but Sybase and MSSQL stored procedures do not return a result set until the cursor is positioned at the end of the set. GetResults forces the cursor to the end of the set.

If a stored procedure returns a result set and output parameters in response to GetResults, the output parameters are stored in the Params property. An application can access the output parameters by indexing into the Params list, or by using the ParamByName method.

Tip: If an application is only interested in the result set returned by a stored procedure, call Open or set the Active property to true.