请问哪错了?
query2.close;
query2.sql.clear;
Query2.SQL.Add('delete jiaoshi Where 班级="'+table1.FieldByName('班级').AsString+'" and 课程="'+table1.FieldByName('课程').AsString+'"');
if (Not Query2.Prepared) then Query2.Prepare;
query2.ExecSQL;
query2.close;
query2.sql.clear;
Query2.SQL.Add('delete jiaoshi Where 班级="'+table1.FieldByName('班级').AsString+'" and 课程="'+table1.FieldByName('课程').AsString+'"');
if (Not Query2.Prepared) then Query2.Prepare;
query2.ExecSQL;
这句有问题,改为:
Query1.sql.add('delete jiaoshi where 班级='+quotedstr(table1.FieldByName('班级').AsString)+' and 课程='+quotedstr(table1.FieldByName('课程').AsString);
query2.sql.clear;
Query2.SQL.Add('delete jiaoshi Where 班级='''+table1.FieldByName('班级').AsString+''' and 课程='''+table1.FieldByName('课程').AsString+''' ');
if (Not Query2.Prepared) then Query2.Prepare;
query2.ExecSQL;
是三个单引号,不是一个单加一个双