IBX.IBStoredProc.TIBStoredProc.Prepare
Delphi
procedure Prepare;
C++
void __fastcall Prepare();
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
procedure function |
public | IBX.IBStoredProc.pas IBX.IBStoredProc.hpp |
IBX.IBStoredProc | TIBStoredProc |
Description
Prepares a stored procedure for execution.
Call Prepare to bind a stored procedure's parameters before calling ExecProc to execute the procedure. Prepare readies a stored procedure's parameters and informs the server of the stored procedure's readiness. These steps allocate system resources and optimize the query for server performance.
Note: A stored procedure is automatically prepared if it is unprepared when the application calls ExecProc. After execution, the stored procedure is then automatically unprepared. If a stored procedure will be executed more than once, it is more efficient for an application to call Prepare explicitly once to avoid repeated and unnecessary preparing and unpreparing of the stored procedure, and then call UnPrepare when the stored procedure is no longer needed.