TSQLStoredProc.ExecProc Method

Executes the stored procedure when it does not return a cursor.

Pascal

function ExecProc: Integer; virtual;

C++

virtual __fastcall int ExecProc();

Description

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.