Data.SqlExpr.TSQLStoredProc.ExecProc

• Up to Parent: TSQLStoredProc

[–] Properties Type: function Visibility: public Source:

Data.SqlExpr.pas

Data.SqlExpr.hpp

Unit: Data.SqlExpr Parent: TSQLStoredProc

Delphi

function ExecProc: Integer; virtual;

C++

virtual int __fastcall ExecProc();

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.

See Also

• StoredProcName

• RowsAffected

• Prepared

• Executing the Command