Setting the collection read mode (Transaction Isolation Level)
With the UNCOMMITTED setting, which allows the reading of uncommitted data, users do not have to wait for other long-running transactions that access the same dataset to complete before their queries can complete.
With the COMMITTED setting, a query reads committed data and returns only data for which the query can get a shared lock.
The base, system-wide transaction isolation level is set on the Process Defaults form. Note that if this setting is unsuitable for all forms and tasks, you can override it for selected forms and tasks. You can set the isolation level for individual reports and stored procedures on the Background Task Definitions form. You can also override the system setting at the form level in WinStudio edit mode. See the Factory Track help for information about setting the Read Mode for a collection and about setting transaction isolation levels.