Jason

> I'll log this as a potential bug. I'm sure you can work around it

by using

> two separate parameters, right?

Wrong! The real query has about 20 fields initiated with the same
value (an encrypted '0') and it would just be too tedious!

I have got round it by using an TIB_Query but thought it was worth
raising.

Regards
Paul

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