Dim cmd As new SQLCommand cmd.C cmd.CommandText = "upd ate ICBOMChild set FEntrySelfZ0142 = a.FItemID from ICBOM As a where a.FInterID = ICBOMChild.FInterID And (a.FItemID <> ICBOMChild.FEntrySelfZ0142 or ICBOMChild.FEntrySelfZ0142 is null)"cmd.ExecuteNonQuery
cmd.CommandText = "upd ate ICBOMChild set FEntrySelfZ0142 = null from ICBOM as a where a.FInterID = ICBOMChild.FInterID and FUseStatus <> 1072"
cmd.ExecuteNonQuery
加好友 
发短信
Post By：2020/7/24 21:50:00 [显示全部帖子]
