TIB_StoredProc Object
Properties Methods

Unit
IB_StoredProc

Declaration
TIB_StoredProc = class(TIB_Dataset)

Description
This component is designed to execute stored procedures that return a single row of output, if any. It will also behave like a TIB_Cursor for procedures that return multiple rows.

Results of this component, if any, are found in the Fields[] array and not in the Params[] array.

Introduced Public Properties
AutoDefineParams  If you do not know the names of the input parameters then set this to true amd have them defined for you internally.
ParamNames  Provides a list of input parameter names to use when the statement is Prepared.
StoredProcForSelect  If the stored procedure is for the purpose of selecting multiple records or for selecting a single record where the SUSPEND statement has been used in the stored procedure then set this property to true.
StoredProcHasDML  After the stored procedure is executed it is necessary to inform the IB_Transaction component if any DML was performed so that it can become active.
StoredProcName  The name of the stored procedure to be executed.

Introduced Public Methods
Create
Destroy
ExecProc   This method will execute the procedure.