Not yet, I'm still working on it.

Regards,
Jason Wharton

----- Original Message -----
From: "Aage Johansen" <aagjohan@...>
To: <ibObjects@yahoogroups.com>
Sent: Thursday, August 14, 2003 11:18 AM
Subject: [IBO] OldParameterOrdering


> Is there a final, permanent, good fix for the "OldParameterOrdering"
problem?
>
> Using IB_SQL built with 4.2.I I'm testing the following
> insert into XSR (USERID,FLT,WRD)
> select :USERID, :FLT, WRD
> from WRDS
> where SWRD starting :SWRD
> where USERID and FLT are integer and smallint, and SWRD is varchar(32).
> 1)
> Preparing (with OldParameterOrdering = 1) gives me
> USERID VarText(32)
> SWRD Integer
> FLT SmallInt
> Obviously, not good.
> 2)
> Preparing (with default OldParameterOrdering) gives me
> USERID Integer
> SWRD SmallInt
> FLT VarText(32)
> Obviously, not good.
>
> Table definition:
> create table WRDS (
> SWRD varchar(32) not Null primary key,
> WRD integer);
> Server version is WI-T1.5.0.3233 Firebird 1.5 Release Candidate 1
> fbclient.dll is 1.5.0.3233
> gds32.dll is 6.3.0.0
>
> What do I have to do to make it
> USERID Integer
> FLT SmallInt
> SWRD VarText(32)
>
> I first saw the problem in my program (using D6 and IBO/4.1.Id), where I
> got message telling me "'<some string>' is not an integer value" or words
> to that effect on the statement
> SomeQuery.ParamByName('SWRD').AsString:=<some string>;
> Will a newer IBO version solve the problem?
>
>
> Regards,
> Aage J.