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.