How to modify the data in the inventory table at one time in the warehouse management software?

roger12

When entering the storage order, you can enter multiple records in DBGrid1 at one time. I want to modify the corresponding records in the inventory table when saving. modify?

zhongshuan

Yes, you can use batch processing, I suggest you go to 2ccc.com to download an example to see, it is relatively simple

roger12

Can you say something specific, or give a code, I did not find relevant content.

roger12

// Modify the existing quantity in the inventory table
ADOQuery1.Close;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add ('Select * from RukuTmp');
ADOQuery1.Open;
// Find all data from the temporary table
ADOQuery1.First;
while not ADOQuery1.Eof do
begin
  ADOQuery2.Close;
  ADOQuery2.SQL.Clear;
  ADOQuery2.SQL.Add ('Select * from Kucun where ChID =: a');
  ADOQuery2.Parameters.ParamByName ('a'). Value: = ADOQuery1.fieldbyname ('ChID'). AsString;
  ADOQuery2.Open;
  ADOQuery2.Edit;
  ADOQuery2.FieldByName ('Kcsl'). AsFloat: = ADOQuery2.fieldbyname ('Kcsl'). AsFloat
    + ADOQuery1.fieldbyname ('Rksl'). AsFloat;
  ADOQuery2.Post;
  ADOQuery1.Next;
end;

xclzc17

update Ku village set KC SL = Ku village.KC SL + Ru library tmp.RK died from Ku village, Ru library tmp where Ku village. CH ID = Ru library tmp.CH ID

四月天

Sum with SUM
with ADOQuery1 do
begin
  close;
  sql.clear;
  sql.add ('update Kucun set Kcsl = c.Kcsl from (select ChID, sum (Kcsl) as Kcsl from RukuTmp group by ChID) c, warehouse where Kucun.ChID = c.ChID');
  execsql;
end;

roger12

xclzc17()
I tried, your method is wrong, you cannot join two tables after Update.

xclzc17

What do you mean?

xclzc17

What database? What does it mean that two tables cannot be joined?

roger12

I am an Access database, and I am prompted at runtime:
Syntax error (operator missing) in query expression 'Kucun.Kcsl + RukuTmp.Rksl from Kucun'.

So I judge it is ', RukuTmp' is not recognized by the program, can I only follow one table after the update?