这个程序的作用是将数据库中相同的项的数量统计出来,将其寸在另一个数据库中!!!!!
while adotable1.RecordCount>=1 do //统计数量
begin
adotable1.First ;
zhi1:=adotable1.fieldbyname('zhi').AsString ;
zhi1:=trim(zhi1);
adotable1.delete;
i:=1;
ADOTable1.Next;
while not ADOTable1.Eof do
begin
name:=adotable1.fieldbyname('zhi').AsString;
name:=trim(name);
if comparestr(name,zhi1)=0 then
begin
adotable1.Delete;
i:=i+1;
adotable1.Next;
end;
if comparestr(name,zhi1)<>0 then
begin
ADOTable1.Next;
end;
end;
adoTable2.TableName:='yltj';
adotable2.active:=true;
with adotable2 do
begin
insert;
fieldbyname('zhi').AsString:=zhi1;
FieldByName('num').AsInteger:=i;
post;
end;
end;
while adotable1.RecordCount>=1 do //统计数量
begin
adotable1.First ;
zhi1:=adotable1.fieldbyname('zhi').AsString ;
zhi1:=trim(zhi1);
adotable1.delete;
i:=1;
ADOTable1.Next;
while not ADOTable1.Eof do
begin
name:=adotable1.fieldbyname('zhi').AsString;
name:=trim(name);
if comparestr(name,zhi1)=0 then
begin
adotable1.Delete;
i:=i+1;
adotable1.Next;
end;
if comparestr(name,zhi1)<>0 then
begin
ADOTable1.Next;
end;
end;
adoTable2.TableName:='yltj';
adotable2.active:=true;
with adotable2 do
begin
insert;
fieldbyname('zhi').AsString:=zhi1;
FieldByName('num').AsInteger:=i;
post;
end;
end;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货