小问题？？！~~~

Question

为什么这段代码运行不起来呢try
   with adoquery1 do
   begin
     SQLStr:= 'select *'+
              'from'+'"trim(label1.caption)"';
     close;
     SQL.Clear;
     SQL.Text:=SQLStr;
     open;
   end;
  except
  end;

Answer 1

SQLStr:= 'select * from '+trim(label1.caption);

Answer 2

try
   with adoquery1 do
   begin
     SQLStr:= 'select *'+                      
              'from'+'trim(label1.caption)';
     close;
     //SQL.Clear;
     SQL.Text:=SQLStr;
     open;
   end;
  except
  end;表名不用加“”的
SQL.Clear浪费