-----Original Message-----
From: Jason L. Wharton [mailto:jwharton@...]
Sent: Thursday, September 13, 2007 8:53 PM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] IBOQuery and Refresh


I just got this report and I will try and get it fixed ASAP.

I'm still in the process of moving so my time is limited but this should be
a quick fix.

Jason

> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On
> Behalf Of Petr Hartman
> Sent: Tuesday, September 11, 2007 6:25 AM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] 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
>
>
>
> __________________________________________________________________________
> _
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> __________________________________________________________________________
> _
> http://www.ibobjects.com - your IBO community resource for Tech Info
> papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>