使用Adoquery连接表,现在我想表不是定的,我用下面的语句有错误,应该怎么写
var
tablename:String;
tablename='表名';
Adoquery.close;
Adoquery.sql.clear;
Adoquery.sql.add('select * from '''+Trim(tablename)+''' ');
Adoquery.open;
help?
var
tablename:String;
tablename='表名';
Adoquery.close;
Adoquery.sql.clear;
Adoquery.sql.add('select * from '''+Trim(tablename)+''' ');
Adoquery.open;
help?
tablename:String;
tablename:='表名';
Adoquery.close;
Adoquery.sql.clear;
Adoquery.sql.add('select * from '+Trim(tablename));
Adoquery.open;
改成:
Adoquery.sql.add('select * from ' + Trim(tablename) );