Data.SqlExpr.TSQLStoredProc.ExecProc

From RAD Studio API Documentation
Jump to: navigation, search

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.

See Also