Read Mode property

Use the Read Mode property to specify the isolation level for transactions when loading a collection. The setting overrides the default value for Collection Read Mode set in the Process Defaults form. The override applies only to the collection for which it is specified.

The Read Mode property permits or prevents "dirty reads."

The setting UNCOMMITTED implements dirty reads, in which no shared locks are issued and no exclusive locks are honored. It is possible to read uncommitted data; values can be changed and rows can appear or disappear in the collection before the end of the transaction. The setting corresponds to the Transact-SQL statement SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED.

The setting COMMITTED specifies that shared locks are held while data is being read to avoid dirty reads, but the data can be changed before the end of the transaction. The setting corresponds to the Transact-SQL statement SET TRANSACTION ISOLATION LEVEL READ COMMITTED.

The property applies to primary and secondary collections.