Data.Win.ADODB.TADOStoredProc.ExecProc

• Up to Parent: TADOStoredProc

Delphi

procedure ExecProc;

C++

void __fastcall ExecProc();

Properties

Type	Visibility	Source	Unit	Parent
procedure function	public	Data.Win.ADODB.pas Data.Win.ADODB.hpp	Data.Win.ADODB	TADOStoredProc

Description

Executes the procedure stored on the server.

Call ExecProc to execute a stored procedure. Before calling ExecProc:

1. Provide any input parameters in the Parameters property. At design-time, a developer can provide parameters using the Parameters Editor. At runtime an application must access the Parameters property directly.
2. Set the Prepared property to true to bind the parameters.

If a stored procedure returns output parameters, they are stored in the Parameters property when ExecProc returns control to the application. An application can access the output parameters using the Parameters property and identifying the particular parameter by its number or by using the ParamByName method and identifying the parameter by its name.

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

See Also

• Active

• Open

• Parameters

• Prepared

• Connection