At 05:37 PM 13/09/2007, Set wrote:

>As far as I can see (admittedly without looking all too carefully),
>your original statement qualified as Helen did, also ought to work.
>The above query should (IMO) be a very good replacement for your
>original query, but IBO should still be able to handle both type of
>queries without barking upon refresh (well, unless you do silly
>things like changing OldParameterOrdering programmatically
>before/when doing refresh).

In fact, Petr really has discovered a regression bug. I've set up
some test cases for Jason using Petr's sample database but, in the
meantime, ParameterOrder support in IBO 4.8.x is not working safely
for TDataset components. You will need to configure
OldParameterOrdering=1 in firebird.conf for both Fb 1.5.x and 2.x.

NOTE There is no sign of the problem in the native TIB_ data access.

Helen