TDatabase BDEClientDataSet两个控件的问题
我编了测试程序cds(BDEClientDataSet)
with cds do
begin
Close;
CommandText := 'Select * From Test Where 1=2';
Open;
Append;
FieldbyName('Name').AsString := 'zhangfeng';
FieldbyName('Num').AsInteger := 1;
FieldbyName('Age').AsInteger := 24;
Post;
ApplyUpdates(0);
end;
上面的测试程序,连接INFORMIX可以成功提交,
用sql monitor跟踪看到的sql为:
SQL Execute: INFORMIX - insert into Test (name, age, num)values (?, ?, ?)
而连接ORACLE时,不成功,提示找不到表名
sql:SQL Execute: ORACLE - insert into "Test" ("NAME", "AGE", "NUM")alues
(?, ?, ?)
表名只动加了引号,导致找不到表名,请问那位知道如何不让ORACLE不填加引号。