Setting transaction isolation levels

To change the base transaction isolation level:

• In the Process Defaults form, select the Collection Read Mode default.
• In the Default Value field, specify either COMMITTED or UNCOMMITTED. If the field is blank, queries use COMMITTED as the transaction isolation level.

To change the transaction isolation level for a report or stored procedure:

• In the Background Task Definitions form, select a background task of the type RPT or SP.
• In the Isolation Level field, select Read Committed or Read Uncommitted. If the field is blank, queries use the transaction isolation level (collection read mode) set on the Process Defaults form.

To change the transaction isolation level for a collection in a form, see the help on Read Mode and Isolation Levels.