2,498
社区成员
发帖
与我相关
我的任务
分享
var
i: Integer;
tmp: array of Variant;
begin
{复制出来的记录codeid取值为1}
with adoqeruy1 do begin
DisableControls;
SetLength(tmp, Fields.Count);
while not adoqeruy1 do begin
for i := 0 to FieldCount - 1 do
tmp[i] := Fields[i].AsVariant;
Append;
for i := 0 to FieldCount - 1 do
Fields[i].AsVariant := tmp[i];
FieldByName(codeid).Asinteger := 1;
next;
end;
Sort:='姓名';{复制完毕记录后按姓名排序}
frReport1.ShowReport;
{删除复制出来的记录}
ADOCommand1.CommandText:='delete x_eng where codeid=1';
ADOCommand1.Execute;
close;
open;{重新打开一次}
EnableControls;
end;
end;