Data.SqlExpr.TSQLStoredProc.ExecProc
Delphi
function ExecProc: Integer; virtual;
C++
virtual int __fastcall ExecProc();
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| function | public | Data.SqlExpr.pas Data.SqlExpr.hpp |
Data.SqlExpr | TSQLStoredProc |
Description
Executes the stored procedure when it does not return a cursor.
Call ExecProc to execute the stored procedure specified by StoredProcName if it does not return a cursor. ExecProc returns the number of rows affected by the stored procedure. This becomes the value of the RowsAffected property.
To speed performance, an application should ordinarily prepare the stored procedure by setting the Prepared property to true before calling ExecProc the first time.
Note: Do not use ExecProc for stored procedures that return a cursor. When the stored procedure returns data, use the Open method or set the Active property to true.