因为Append方法需要指定索引值,
所以你不妨将你的Coding改成这样
DataModule1.adoquery1.close;
DataModule1.adoquery1.sql.text:='select * from ddxx';
DataModule1.adoquery.open;
with DataModule1.adoquery1 do
begin
last;
id:=fieldbyname('ddid').asinteger;
sql.Text := 'Insert into ddxx(ddid) values(:id)'
Parameters[0].value := id+1;
ExecSQL;
end;
代码应没错,就好象:
DataModule1.adoquery1.close;
DataModule1.sql.text:='select * from ddxx';
DataModule1.adoquery.open;
with DataModule1.adoquery1 do
begin
last;
id:=fieldbyname('ddid').asinteger;
append;
edit;
fieldbyname('ddid').asinteger:=id+1;
post;
end;