Subject Re: [IBO] tibostoredproc 4.2Fp changed params not used
Author Helen Borrie (TeamIBO)
At 07:40 PM 06-03-02 +0100, you wrote:
>Hi Uwe,
>Uwe Cramer wrote:
> > Hello,
> > when i use the component and change the input param values via paramsbyname
> > the output param result for the first call is correct.
> > but the results from the next calls with changed input param values are the
> > same as the first call.

Frank Ingermann wrote

>You could try to explicitly Prepare the storedproc before every execution
>and Unprepare it afterwards. I vaguely remember a bug (in IB5.6) where
>repeated calls to storedprocs without explicit preparation would cause
>strange effects like the one you describe... maybe a hint.

Jason's description of the bug appears on the News page of the website. It
would be interesting to know which database and version you are using,
since I'm pretty sure Claudio fixed this bug in Firebird RC 2.

Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at