I'll log this as a potential bug. I'm sure you can work around it by using
two separate parameters, right?

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: <paulhope@...>
To: <IBObjects@egroups.com>
Sent: Wednesday, December 06, 2000 6:43 AM
Subject: [IBO] Bug in 3.6A IBOQuery


> Hi
>
> There appears to be a bug in TIBOQuery when used for Insert SQL and a
> parameter is repeated.
>
> Create table test(f1 varchar(15),f2 varchar(15))
>
> SQL is set to
>
> 'insert into test values(:p1,:p1)'
>
> query is connected to autocommit transaction.
>
> code is
>
> Query.ParamByName('p1').AsString:='test';
> Query.execSQL;
>
> result is
>
> both fields are null.
>
> Works OK with IB_Query.
>
> Regards
> Paul
>