Setting Isolation Levels

SourcePro DB : DB Access Module for Microsoft SQL Server User’s Guide : Technical Information : Transaction Processing : Setting Isolation Levels

You can use the isolation() method of RWDBConnection to set the isolation level of the connection. Table 5 shows the mapping between the IsolationType argument you pass and the isolation level set on the connection

Table 5 – Setting the isolation level
RWDBConnection::IsolationType	Microsoft SQL Server Isolation Level
Unknown	SQL_TXN_READ_UNCOMMITTED
ANSILevel1	SQL_TXN_READ_UNCOMMITTED
ANSILevel2	SQL_TXN_READ_COMMITTED
ANSILevel3	SQL_TXN_REPEATABLE_READ

To determine the isolation level, call RWDBConnection::isolation() without an argument.