求教,sql语句与触发器相关问题 Post By:2012/10/11 22:40:00 [只看该作者]
Dim sql1 As String = "UPDATE {库存表} set 单据号 = Case WHEN ID = "& sql &" Then '"& s6 &"' Else 单据号 End ,虚存量 = Case WHEN 虚存量 <= "& s5 &" And ID = "& sql &" Then 0 WHEN 虚存量 > "& s5 &" And ID = "& sql &" Then 虚存量 - "& s5 &" Else 虚存量 End " cmd.CommandText = sql1 cmd.ExecuteNonQuery() > 0