Thank you so much Helen...You're the best!!!

"Helen Borrie" <helebor@...> wrote in message
news:5.1.0.14.2.20030419225846.030a2228@......

> 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.
>
> cheers,
> Helen
>
>
>
>
>

___________________________________________________________________________

> IB Objects - direct, complete, custom connectivity to Firebird or

InterBase

> without the need for BDE, ODBC or any other layer.
>

___________________________________________________________________________

> http://www.ibobjects.com - your IBO community resource for Tech Info

papers,

> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>