Bde.DBTables.TStoredProc.GetResults

From RAD Studio API Documentation
Jump to: navigation, search

Delphi

procedure GetResults;

C++

void __fastcall GetResults(void);

Properties

Type Visibility Source Unit Parent
procedure
function
public
Bde.DBTables.pas
Bde.DBTables.hpp
Bde.DBTables TStoredProc

Description

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

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.

See Also