Setting Transaction Isolation Levels

To change the base transaction isolation level

  1. Open the Process Defaults form.
  2. Select the Collection Read Mode default.
  3. In the Default Value field, type either COMMITTED or UNCOMMITTED. Note that 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

  1. Open the Background Task Definitions form.
  2. Select a background task of the type RPT or SP.
  3. In the Isolation Level field, select Read Committed or Read Uncommitted. Note that 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 online documentation for WinStudio design mode.


Related Topics

About Transaction Isolation Levels