Subject Re: [IBO] Possible bug in parsing this SQL statement's parameters
Author Daniel Albuschat
2006/10/5, Helen Borrie <helebor@...>:
> At 10:39 PM 5/10/2006, you wrote:
> >By the way: IBO version is 4.2.Ib and Firebird version is 1.5.0.4290 (Linux).
> This is probably the most USEFUL piece of information about your
> problem. In short, that (very, very old) version of IBO is not
> compatible with the default settings in Firebird 1.5, which corrected
> an old Interbase and Fb 1.0 bug.

Don't call it "old" -- call it "stable". :-)
We're currently converting our application from Delphi 5 to Delphi 7
and this conversion will have introduced a few unpredictable
bugs in our software that need to be found anyways, so I don't want
to risc to upgrade IBO and get different behaviour in many more
places, too.
So I'll stay with the current version. I'm rather happy with it, even
with that bug that I could easily find a workaround for.
That said, I didn't know that this IBO version was "very, very old"
or even "ancient" -- after all, I don't think it's any older than
2 years maybe.

> It's such an old issue, I'd practically forgotten about it. You need
> to either upgrade IBO to
> v.4.3Aa or higher, or set the OldParameterOrdering property in
> firebird.conf to 1 (and uncomment it, of course).

Uhm, that'd definitely be too much work. We'd have to change all
our client's configuration files, etc.
I'll just stick with it as it is.

> OldParameterOrdering is *not* meant to be a permanent solution,

That's for sure.

> merely an accommodation at the time, to make the transition less
> disruptive for IBO developers. It makes any databases on your server
> prone to unpredictable wrong results if accessed with anything
> *other* than those very ancient IBO versions.
>
> Helen

Thanks again for your explanation. Maybe we'll consider
upgrading IBO in a couple of weeks, but I don't think I want to
do it right now. :-)

Regards,
Daniel Albuschat

--
eat(this); // delicious suicide