At 11:36 AM 1/10/2003 +1000, you wrote:

> > >We are using:
> > > - Interbase Server 5.6
> > > - Interbase Client 5.6.0.29
> >
> > This is simply the IB 5.x/IB 6 XSQLDA bug rearing its head and not being
> > solved by your code because of a simple error in the sequence of your
>handler:
> >
>
>Good morning Hellen
>
>Are you suggesting that IB versions after V6 (ie. 7!), has this bug fixed?

I simply don't know. If you have IB 6.5 or 7, you could look up the
bug-fix list in the release notes; or just run a test-case.

>I get this bug regularly (haven't tried IB 7 yet). What about FB?

It was fixed in FB 1.0.

With Fb 1.5 another (potentially more serious) bug with parameters was
fixed, to do with the order in which return values were presented in the
XSQLDA. It was such a long-term bug that IBO has long included processing
to work around it. It is still needed for all IB and FB versions before Fb
1.5.

If you use 1.5, you need to go into firebird.conf and activate the
OldParameterOrdering parameter. This fixes things for your IBO apps but,
unfortunately, it breaks things for any non-IBO apps using the same
Firebird server. Jason will be doing a "workaround for the workaround" for
some forthcoming point release of IBO. The solution isn't as simple as it
might appear, either...

Helen