ADO复杂事务回滚问题之循环操作事务,请用ASP事务对象ObjectContext

描述:
BeginTrans
While (Table1)
Create(ADO.RecordSet1)
SELECT Table2 //ADO.RecordSet1
ADO.RecordSet1.Close()
SET ADO.RecordSet1=Nothing
UPDATE Table2
Wend
EndTrans

当第二次循环时,由于上次(第一次)对Table2执行过修改,且在事务处理中,当第二次执行SELECT时,报错“没有END”,请问如何:释放事务处理时对执行过Insert,Update,Delete操作过的表的锁定、访问权限?

---------------------------------------------------------------

1@ TRANSACTION = Required 

<%

Set Conn=CreateObject("adodb.connection")
'一些数据库操作
Conn.Close
Set Conn=Nothing

'提交或者回滚事务
ObjectContext.SetAbort
'ObjectContext.SetComplete

Published At
Categories with Web编程
Tagged with
comments powered by Disqus