这还不简单在程序里这样写
procedure tform1.buttomclick(sender:tobject);
begin
with adoquery1 do //这段代码
begin
active:=false;
Sql.clear;
SQL.add('select * from table1');
active:=True;
end;
end;
procedure tform1.buttomclick(sender:tobject);
begin
with adoquery1 do //这段代码
begin
active:=false;
Sql.clear;
SQL.add('select * from table1');
active:=True;
end;
end;
adoquery1.close;
adoquery1.sql.clear;
adoquery1.sql.add('select * from table2');
adoquery1.open;
adoquery1.sql.add ('select * from '+a);
adoquery1.close;
adoquery1.sql.clear;
adoquery1.sql.add('select * from table2');
adoquery1.open;
adoquery1.sql.clear;
adoquery1.sql.add('select * from :table);
adoquery1.Parameters['table'].Value := combox1.text;
adoquery1.open;
adoquery1.close;
adoquery1.sql.clear;
adoquery1.sql.add('select * from table2');
adoquery1.open;
象上边snakeguo(枫) 这位仁兄所说!如此以来,你按第一个按钮将显示由table1中查出的记录。按另外一个按钮,将显示table2中查询的记录!
query1.close;
Query1.sql.clear;
Query1.sql.add(format(Querystr,[edit1.text]);//edit1.text为你输入表名
query.open;
adoquery1.sql.clear;
adoquery1.sql.add('select * from :table);
adoquery1.Parameters['table'].Value := edit1.text;
adoquery1.open;
显示出错
[Error] Unit1.pas(36): Incompatible types: 'Integer' and 'String'
是什么原因
TableName:String;
tableName:='table1';
With AdoQuery1 do
Begin
Close;
Sql.clear;
Sql.Add('Select * from '+tablename);
Prepared;
Open;
end;
或者作一个过程,通过参数去赋值!