Deletequery是否指向了sc.db所在的数据库?

解决方案 »

  1.   

    deletequery.databasename:='';
    deletequery.Close;
    deletequery.SQL.Add('delete from sc.db');
    deletequery.SQL.Add('where sno=:snoref');
    deletequery.SQL.Add('and cno=:cnoref');
    deletequery.Prepare;
    deletequery.ParamByName('snoref').AsInteger:=sno;
    deletequery.ParamByName('cnoref').AsInteger:=cno;
    deletequery.ExecSQLdeletequery.Prepare;放错位置了
      

  2.   

    你应先clear一下,然后试着把sc.db中的.db去掉