Have you checked the ParameterOrder property of your TIBODatabase or
TIB_Connection component? Is it perhaps set to poOld?.



Roger Vellacott

Passfield Data Systems Ltd

Sales and General +44 1404 514400

Direct Line +44 1404 514402

________________________________

From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On
Behalf Of Petr Hartman
Sent: 12 September 2007 07:21
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 IBOQuery1.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]