| Subject | Re: [IBO] TIB_SToredProc problems |
|---|---|
| Author | Helen Borrie |
| Post date | 2004-10-22T04:02:08Z |
At 01:44 PM 22/10/2004 +1000, you wrote:
SQL property, use Execute to execute it, read Fields[] after execution to
read the return values. Use parameters for re-executions of the same proc
and keep it prepared beween re-executions.
There's not much point in recycling a SP or DSQL object; but if you want to
do so with a tib_dsql, you can.
Helen
>Hi,Forget about TIB_StoredProc. Use TIB_DSQL. Use EXECUTE PROCEDURE in your
>
>
>I am having some very strange behaviour using the TIB_StoredProc.
>
>Is it possible to recycle the TIB_StoredProc for multiple Execute
>Procedures?
SQL property, use Execute to execute it, read Fields[] after execution to
read the return values. Use parameters for re-executions of the same proc
and keep it prepared beween re-executions.
There's not much point in recycling a SP or DSQL object; but if you want to
do so with a tib_dsql, you can.
Helen