我用Delphi连的Access库,用ADOTable操作数据库,在删除时有时怎么报错?
报错信息为“Key column information is insufficient or incorrect,too
many rows were effected by updata”
报错信息为“Key column information is insufficient or incorrect,too
many rows were effected by updata”
调试欢乐多
if ADOTable1.RecordCount>0 then ADOTable1.Delete;
修改为一个SQL语句
truncate table tablename
sql.Add('Deleto from Lend Where ReaderID=:ReaderID');
ExecSQL;