怎么在ADOQuery中动态设置欲查询的表

[listen_snow]

如题

[李_军]

ADOQuery.Sql.Clear;
ADOQuery.Sql.add('Select * From TableName');
ADOQuery.Open;

[listen_snow]

TableName需要作为参数传递过去，这个怎么实现是？

[Wang_xiaoni]

ADOQuery1.Sql.Clear;
adoquery1.connectstring:='';//连接字符串
ADOQuery1.Sql.add('Select * From TableName');
ADOQuery1.active:=true;
//或ADOQuery1.ExecSQL('SQL语句');

[星星]

没必要用参数的！

ADOQuery.Close;
ADOQuery.Sql.text:='Select * From '+trim(edtTableName.text);
ADOQuery.Open;

[xintan]

ADOQuery.Close;
ADOQuery.Sql.text:='Select * From '+trim(edtTableName.text);
ADOQuery.Open;

[wujunwei]

要参数的话是:

var TableName:string;

begin
TableName:='你要赋的表名';
adoquery.close;
adoquery.sql.clear;
adoquery.sql.add('select * from '+TableName);
adoquery.open;
end;