Indicates the level of isolation for a Connection object.
Sets or returns one of the following IsolationLevelEnum values:
Constant |
Value |
Description |
adXactUnspecified |
-1 |
If the provider is using a different IsolationLevel than specified but which one cannot be determined, the property returns this value. |
adXactChaos |
16 |
Indicates that you cannot overwrite pending changes from more highly isolated transactions. |
adXactBrowse |
256 |
Indicates that from one transaction you can view uncommitted changes in other transactions. |
adXactReadUncommitted |
256 |
Same as adXactBrowse. |
adXactCursorStability |
4096 |
Indicates that from one transaction you can view changes in other transactions only after they've been committed. (Default.) |
adXactReadCommitted |
4096 |
Same as adXactCursorStability. |
adXactRepeatableRead |
65536 |
Indicates that from one transaction you cannot see changes made in other transactions, but that requerying can bring new recordsets. |
adXactIsolated |
1048576 |
Indicates that transactions are conducted in isolation of other transactions. |
adXactSerializable |
1048576 |
Same as adXactIsolated. |
Use the IsolationLevel property to set the isolation level of a Connection object. The IsolationLevel property is read/write. The setting does not take effect until the next time you call the BeginTrans method. If the level of isolation you request is unavailable, the provider may return the next greater level of isolation.
file: /Techref/language/asp/comp/daprop03_7.htm, 3KB, , updated: 1996/11/21 18:01, local time: 2024/12/1 16:13,
18.118.30.137:LOG IN
|
©2024 These pages are served without commercial sponsorship. (No popup ads, etc...).Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE. Questions? <A HREF="http://massmind.org/Techref/language/asp/comp/daprop03_7.htm"> IsolationLevel Property (ADO)</A> |
Did you find what you needed? |
Welcome to massmind.org! |
Welcome to massmind.org! |
.