Subject Re: [IBO] Correct Way to Use TIB_StoredProc
Author Helen Borrie
At 08:19 AM 19/04/2003 -0400, you wrote:
>What is the correct way to re-use a TIB_StoredProc component. What do I
>need to reset to re-use the component. Do I have to clear the ParamNames
>and ParamByName first values? Do they automatically get cleared. I am
>dynamically setting the values for the component and would like to re-use
>the component for executing other stored procedures.

Although the TIB_StoredProc component exists for compatibility, it's
actually more efficient to use TIB_DSQL and TIB_Query for executable and
selectable stored procedures, respectively.

With any of the components, the Params[] array gets cleared whenever the
component is unprepared. Unprepare occurs whenever you change the SQL
property or, in the case of TIB_StoredProc, the StoredProcName.