AdoIsolationLevelEnum() Function

<< Click to Display Table of Contents >>

Navigation:  Enums >

AdoIsolationLevelEnum() Function

Previous pageReturn to chapter overviewNext page

Purpose

All the values of the IsolationLevel Enum:

The type of action to be performed when SetPermissions is called.

 

Prototype

 

FUNCTION AdoIsolationLevelEnum ( ) AS ARRAY

Return

ARRAY        Every row in this array has 2 values:

       The numeric value of the Enum value

       A text representation of this value

 

This array can be used to validate values, and to print a meaningful description of the values during debugging You can pass this array to the AdoEnum2Str() function to convert the value of an Enum to a string

 

Description

 

List of possible values

adXactUnspecified -1        The provider is using a different isolation level than specified
adXactChaos 16        You cannot overwrite pending changes from more highly isolated transactions.
adXactBrowse 256        from one transaction you can view uncommitted changes in other transactions.
adXactReadUncommitted256        Same as adXactBrowse.
adXactCursorStability 4096        From one transaction you can view changes in other transactions only after they've been committed.
adXactReadCommitted 4096        Same as adXactCursorStability.
adXactRepeatableRead 65536        From one transaction you cannot see changes made in other transactions, but that requerying can bring new recordsets.
adXactIsolated 1048576        Transactions are conducted in isolation of other transactions.
adXactSerializable 1048576        Same as adXactIsolated.

 

 

See Also

Enums, AdoEnum2Str(), AdoStr2Enum()