下面是我的插入代码,不过更新的是所有记录,而不是选中的一条记录 with DBGrid1.SelectedRows do begin qryDetail.DisableControls; try with qrytemp do begin close; sql.Clear; sql.Add('update A set A.数量=A.数量+B.数量,A.金额=A.金额+B.金额,A.单价=((A.金额+B.金额)/(A.数量+B.数量)) from kc2 A'); sql.Add('inner join rukudetail B on B.品名=A.品名'); sql.Add('inner join rukumaster C on C.入库单单号=B.入库单单号'); sql.Add('where C.state=0'); execsql; end; finally qryDetail.EnableControls; end; end;
begin
qryDetail.DisableControls;
try
with qrytemp do
begin
close;
sql.Clear;
sql.Add('update A set A.数量=A.数量+B.数量,A.金额=A.金额+B.金额,A.单价=((A.金额+B.金额)/(A.数量+B.数量)) from kc2 A');
sql.Add('inner join rukudetail B on B.品名=A.品名');
sql.Add('inner join rukumaster C on C.入库单单号=B.入库单单号');
sql.Add('where C.state=0');
execsql;
end;
finally
qryDetail.EnableControls;
end;
end;
sql.Clear;
当然是所有记录了啊
加入你的代码后还是不行啊