2,498
社区成员
发帖
与我相关
我的任务
分享
qrysaveKC.First;
while not qrysaveKC.eof do
begin
with qrydjh do
begin
Close;
sql.clear;//加上這句看看
sql.Add('update YCL_dtkc set kcsl=kcsl-:grsl where YLBM=:bh and YLgg=:gg');
ParamByName('bh').AsString := qrysaveKC.fieldbyname('YLBM').AsString;
parambyname('gg').AsString := qrysaveKC.fieldbyname('YLgg').AsString;
parambyname('GRSL').asfloat := qrysaveKC.fieldbyname('GRSL').AsFloat;
ExecSQL;
end;
qrysaveKC.Next;
end;
qrysaveKC.First;
while not qrysaveKC.eof do
begin
with qrydjh do
begin
Close;
sql.clear;
sql.Add('update YCL_dtkc set kcsl=kcsl-:grsl where YLBM=:bh and YLgg=:gg');
ParamByName('bh').AsString := qrysaveKC.fieldbyname('YLBM').AsString;
parambyname('gg').AsString := qrysaveKC.fieldbyname('YLgg').AsString;
parambyname('GRSL').asfloat := qrysaveKC.fieldbyname('GRSL').AsFloat;
ExecSQL;
end;
qrysaveKC.Next;
end;