|
|
|
|
|
| | |
| |
Active Server Pages ASP a directory of ASP tutorials applications scripts components and articles for the novice to professional developer. 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
