批量更新tbl生产计划明细表!MO字段

yanwei82123300

批量更新tbl生产计划明细表!MO字段
各位老师我想依据tblMAX_MO表中的值来批量更新tbl生产计划明细表!MO字段（递增+1）,谢谢

yanwei82123300

各位老师给看看，谢谢了

todaynew

update tbl生产计划明细表 set MO="M1"

yanwei82123300

todaynew 发表于 2013-9-20 14:23
update tbl生产计划明细表 set MO="M1"

老师理解错误了我的意思是将MO的字段进行批量增加

djt

先做一个生成表查询
SELECT t1.Co_Number, count(*)+(select Mo_Number from tblMax_Mo) AS ListNo INTO ListNo
FROM [select Co_Number from tbl生产计划明细表 group by Co_Number]. AS t1 INNER JOIN [select Co_Number from tbl生产计划明细表 group by Co_Number]. AS t2 ON t1.Co_Number>=t2.Co_number
GROUP BY t1.Co_Number;
再做一个update更新
UPDATE tbl生产计划明细表 AS t1 INNER JOIN ListNo AS t2 ON t1.Co_Number=t2.Co_Number SET t1.Mo = t2.ListNo;

Henry D. Sy

1. Dim rs As New ADODB.Recordset
   
2.     Dim i As Long
   
3.     Dim sSQL As String
   
4.     i = DLookup("MO_NUMBER", "tblMAX_MO")
   
5.     sSQL = "select Mo from tbl生产计划明细表"
   
6.     With rs
   
7.         .Open sSQL, CurrentProject.Connection, adOpenKeyset, adLockOptimistic
   
8.         Do While Not .EOF
   
9.             rs.Fields(0) = i
   
10.             .MoveNext
    
11.             i = i + 1
    
12.         Loop
    
13.         .UpdateBatch
    
14.         .Close
    
15.     End With
    
16.     Set rs = Nothing

复制代码

yanwei82123300

谢谢上面二位老师了