Subject IBOQuery and Refresh
Author Petr Hartman
Hi,

I have IBO 4.8.6. I have IBOQuery running the following query:

select
ID, ZKR, DATUM, (select NAZ from TAB2 where ID = TAB1.ID and TYP = :TYP)
as NAZ
from TAB1
where DATUM = :DATUM

This is the piece of code, that I use for opening the query:

IBOQuery1.ParamByName('DATUM').asDateTime := StrToDate('1.1.2007');
IBOQuery1.ParamByName('TYP').asInteger := 2;
IBOQuery1.Open;

When I call IBOQuery.Refresh, I give the following error:

ISC ERROR CODE:335544569

ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -303
conversion error from string "2"

This error occurs only if there is OldParameterOrdering = 0 in
firebird.conf. If there is OldParameterOrdering = 1, everything is OK.
I have tried FB 1.5.4 and FB 2.0.1, with the same result.

Kind regards

Petr Hartman