Setting transaction isolation levels

Setting the base transaction isolation level

To change the base transaction isolation level, perform these actions:

1. In the Process Defaults form, select the Collection Read Mode process default.
2. In the Default Value field, specify either COMMITTED or UNCOMMITTED.

   If the field is blank, queries use COMMITTED as the default transaction isolation level.

Overriding the transaction isolation level for a report or stored procedure

To change the transaction isolation level for a report or stored procedure, perform these actions:

1. In the Background Task Definitions form, select a background task of the type RPT or SP.
2. In the Isolation Level field, select Read Committed or Read Uncommitted.

   If the field is blank, queries use the transaction isolation level as set for the Collection Read Mode process default on the Process Defaults form.

Overriding the transaction isolation level for an individual form

To change the transaction isolation level for a collection in a form, use the Read Mode field in the designer (Web Designer in the web client or Design Mode in the Windows client).