How can the following while code be optimized? (Modify the existing quantity in the inventory table after storage)

xclzc17

If the table RukuTmp has a large amount of data, change the SQL and do not fetch all the columns, only the required columns
ADOQuery1.SQL.Add ('Select Rksl, ChID from RukuTmp');

roger12

I tried it, the method of Xingyu didn't work either. Maybe it's a problem with Access.
Thank you for your help, I will use while first.