Subject | Bug in 3.6A IBOQuery |
---|---|
Author | paulhope@allcomm.co.uk |
Post date | 2000-12-06T13:43:07Z |
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
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