query得问题？？在线等待

Question

with Q_CT do //确定使用该教室的课程
                                   begin
                                      SQL.Clear;
                                      SQL.Add('SELECT ID');
                                     SQL.Add('FROM T_CourseFree1');
                    SQL.Add('WHERE CLASSROOM='+LabelRoom.Caption+'''');
                                       ExecSQL;
                                      Filtered:=False;//出现错误处 
                                   Open;
                                  First;
                                 ....
                                       end
错误提示:...Missing right quote...

Answer 1

你的where后面的表达式写错了,应为：
SQL.Add('WHERE CLASSROOM='''+LabelRoom.Caption+'''');

Answer 2

还是haoco心细 好象在一开始还要Close，加上更好的！