|
程序里有段下面的代码,大家帮我看看是原来注掉的好,还是新的二句代码好?
CNN.Execute "UPDATE tmb SET sl=sl-" & LV1.ListItems(i).SubItems(2) & " where tm=" & CheckString(LV1.ListItems(i).SubItems(4))
CNN.Execute "UPDATE tmb SET sl=0 where sl<0" '当数量小于0时置0
's = "select sl from tmb where tm=" & CheckString(LV1.ListItems(i).SubItems(4))
'RST.Open s, CNN, 1, 3
'If Not RST.EOF Then
' RST.Fields("sl").Value = IIf(RST.Fields("sl").Value > Val(LV1.ListItems(i).SubItems(2)), RST.Fields("sl").Value - LV1.ListItems(i).SubItems(2), 0) '减去相应的数量,以后还要完善
' RST.Update
'End If
'RST.Close |
|