为何不能复制记录???
if tablename = 'LocalGuest' then
begin
Oldtable:='OldLocalGuest';
Sql:='insert into '+Oldtable+' select *from '+tablename+' where 旅客编码='+''''+idedit.Text+'''';
end else
if tablename = 'ForeignGuest' then
begin
Oldtable:='OldForeignGuest';
Sql:='insert into '+Oldtable+' select *from '+tablename+' where 旅客编码='+''''+idedit.Text+'''';
end;
adoquery2.Close;
adoquery2.SQL.Clear;
adoquery2.SQL.Add(sql);
adoquery2.ExecSQL;
明明Oldtable表没没有这条记录,却说“索引重复...” 不能复制啊!!!