for i:=1 to data.ADOQuery2.recordcount do
begin
data.ADOTable2.Append;
data.ADOTable2.Fields.fields[0]:=data.ADOQuery2.fields.fields[0];
data.ADOTable2.Fields.fields[1]:=data.ADOQuery2.fields.fields[1];
data.ADOTable2.Fields.fields[2]:=data.ADOQuery2.fields.fields[2];
........data.ADOQuery2.Next;
data.ADOTable2.Post;
end;
begin
data.ADOTable2.Append;
data.ADOTable2.Fields.fields[0]:=data.ADOQuery2.fields.fields[0];
data.ADOTable2.Fields.fields[1]:=data.ADOQuery2.fields.fields[1];
data.ADOTable2.Fields.fields[2]:=data.ADOQuery2.fields.fields[2];
........data.ADOQuery2.Next;
data.ADOTable2.Post;
end;
data.adoquery.sql.clear;
data.adoquery.sql.add('create table table_Temp...');
data.adoquery.ExecSQL;
data.adoquery.close;
data.adoquery.sql.clear;
data.adoquery.sql.add('select 成绩 into table_Temp from perinfor_input ');
data.adoquery.sql.add('where 项目名称=:items');
data.adoquery.ExecSQL;
adoquery.sql.clear;
adoquery.sql.add('create table table_Temp');
adoquery.ExecSQL;
adoquery.close;
adoquery.sql.clear;
adoquery.sql.add('select 姓名 into table_Temp from perinfor_input ');
adoquery.ExecSQL;
datasource1.DataSet:=adoquery;
错误类型:
table_temp已经存在:请指点?