在某一个事件中这样来执行事务可行吗？？？
SQL = "select * from [Table] WITH (ROWLOCK) where ProNum2= '001 ' "
rs.Open SQL, cnMain, 1, 3
rs( "cun ") = 1000
rs.Update
rs.Close
Set rs = Nothing
cnMain.Execute ( " update [Table1] WITH (ROWLOCK) set pronum2=1 ' where pronum= '0001 ' ")
cnMain.Execute ( " update [Table2] WITH (ROWLOCK) set pronum2= '2 ' where pronum= '0002 ' ")
[解决办法]
应该是cnMain这个吧
而不是conn
[解决办法]
...................帮顶
