--- In IBObjects@yahoogroups.com, "Petr Hartman" <petr.hartman@...> wrote:

>
> 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
>

A wild guess; Try once to name the parameters differently than the
fields. I have a vague memory of having to do some workarounds when I
started off with IBO, the strange things happening whenever I was
using parameters before the 'FROM'.

Also try the native components. Maybe there was a fix for them that
did not make it into the TIBO flavour.

HTH,

/Dany