with mcenterdata.backupdata do
begin
Close;
Sql.Clear;
Sql.Add('select * from : dbname where cos<>cox');
Params.ParamValues['dbname']:=DateToStr(DateTimePicker1.Date)+'goods';
Open;
end; 为什么不行?
begin
Close;
Sql.Clear;
Sql.Add('select * from : dbname where cos<>cox');
Params.ParamValues['dbname']:=DateToStr(DateTimePicker1.Date)+'goods';
Open;
end; 为什么不行?
begin
Close;
Sql.Clear;
Sql.Add('select * from : dbname where cos<>'''cox''');
Params.ParamValues['dbname']:=DateToStr(DateTimePicker1.Date)+'goods';
Open;
end;
begin
Close;
Sql.Clear;
Sql.Add('select * from : dbname where cos<>''cox''');
Params.ParamValues['dbname']:=DateToStr(DateTimePicker1.Date)+'goods';
Open;
end;
Sql.Add('select * from '+tablename);//tablename可以动态的变化
问题解决了。