Jason,

 

this issue was resolved for me, because Helen Borrie sent to the support list your fix for this bug (function MakeLookupSQL in IB_Parse and function TIB_BDataset.SysLookupKeyForBufferFields in IB_Components).

I'm sorry, I can't test this fix in your new version, because my account has already expired and I didn't buy a new subscription yet, so I can't download the new version.

 

Kind regards,

Petr Hartman

 

From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf Of Support List
Sent: Tuesday, April 26, 2011 3:40 PM
To: 'Petr Hartman'; IBObjects@yahoogroups.com
Subject: [IBO] RE: IBOQuery and Refresh

 
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

[Non-text portions of this message have been removed]