简单示例。作为字段名注意名字约束,x字段值不能有特殊符号。
procedure TForm1.Button1Click(Sender: TObject);
begin
with ADOQuery1 do
begin
Close;
Sql.Clear;
Sql.Add('select x from a');
Open;
if RecordCount>0 then
with ADOQuery2 do
begin
Close;
Sql.Clear;
Sql.Add('create table b ( '+ADOQuery1.Fields[0].AsString+' varchar(10))');
ShowMessage(Sql.Text);
ExecSql;
ADOQuery1.Next;
while not ADOQuery1.EOF do
begin
Sql.Clear;
Sql.Add('alter table b Add '+ADOQuery1.Fields[0].AsString+' varchar(10)');
ExecSql;
ADOQuery1.Next;
end;
end;
end;
end;