Petr,

Was this issue ever resolved for you?
For some reason your email was still in a folder awaiting confirmation of
resolution.

Would you like to test to see if my new version works properly?

Thanks,
Jason LeRoy Wharton
www.ibobjects.com

> -----Original Message-----
> From: Petr Hartman [mailto:petr.hartman@...]
> Sent: Tuesday, September 11, 2007 7:25 AM
> To: IBObjects@yahoogroups.com
> Subject: IBOQuery and Refresh
>
> 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