|
|
|
|
|
| | |
| |
Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
About Transactional ASP |
|
From: |
Air |
|
Date: |
1/24/2000 11:43:36 AM |
|
IP: |
203.83.86.107 |
Can anybody teach me how to write transactional ASP? I need to update 3 tables in one transaction. Can I use ObjectContext.SetAbort to rollback all 3 changes on the database? My code is as following:
<%Transaction = Required%>
... create those objects need here ...
Recordset1.AddNew
...
...
Recordset1.Update
Recordset2.AddNew
...
...
Recordset2.Update
Recordset3.AddNew
...
...
Recordset3.Update
ObjectContext.SetAbort
Why this codes cannot rollback all changes? How should I write the code in order to rollback all 3 changes?
Please be kind to answer me... thanks a lot.
|
Follow Up - How can I make my asp transactional??? - Laura 9/28/2000 12:31:14 PM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
