READMODE keyword
Applies to
Data sources for forms
Component list sources of the type IDO Collection
Validators of the type In Collection
Data binding for tree components
Description
Sets the isolation level for transactions when loading a collection, permitting or preventing dirty reads.
Syntax
READMODE(COMMITTED | UNCOMMITTED)
| Part | Description |
| COMMITTED | Specifies that shared locks are held while data is being read to avoid dirty reads. The setting corresponds to the Transact-SQL statement SET TRANSACTION ISOLATION LEVEL READ COMMITTED. |
| UNCOMMITTED | Implements dirty reads, in which no shared locks are issued and no exclusive locks are honored. The setting corresponds to the Transact-SQL statement SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED. |
Remarks
The READMODE setting overrides the default value for Collection Read Mode specified in the core form “Process Defaults”. If the keyword is not used in a collection specification, the IDO returns collections using the default value. The override applies only to the object for which it is specified.