Daniel

> Try upgrading to the latest version 3.6C and see if this problem is

still

> present.
>

I'd rather not at present :-) I like to give a new release a few
days to settle down! I have got round it by using an IB_Query for
now.

Regards
Paul

> Daniel Rail
> Senior System Engineer
> ACCRA Group Inc. (www.accra.ca)
> ACCRA Med Software Inc. (www.filopto.com)
> At 2000-12-06 09:43, you wrote:
> >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
> >
> >
> >
> >eGroups
>
>Sponsor<http://rd.yahoo.com/M=102308.1038796.2731130.908943/D=egroupm

ail/S=1700007183:N/A=466331/?http://www.yahoo.com>

> >