麻烦检查一下错误,十分感谢!
qzmp 2003-02-27 10:14:51 procedure TForm2.Button8Click(Sender: TObject);
var
bname:string;
begin
if table1.RecordCount>0 then
begin
table1.First;
while not table1.eof do
begin
bname:=table1.fieldbyname('code').asstring+table1.fieldbyname('name').asstring;
query1.databasename:='dd';
query1.Close;
query1.SQL.clear;
query1.sql.Add('select * from sysobjects where name=:q1');
query1.ParamByName('q1').AsString:=bname;
query1.execsql;
if query1.isempty then
begin
query1.Close;
query1.sql.Clear;
query1.sql.Add('create table :q2 ([rq] [INT] NOT NULL)');
query1.ParamByName('q2').asstring:=bname;
query1.Execsql;
table1.moveby(1);
end
else
application.MessageBox('资料已经存在!','提示窗口',mb_iconinformation+mb_ok);
table1.moveby(1);
end;
table1.first;
end;
end;