A script-enabled browser is required for this page to function properly.

Coordination Property

Description

Specifies how and when the population phase of block coordination should occur. Specify the coordination desired by setting the Deferred and Auto Query properties. When you set these properties at design time, Oracle Forms creates or modifies the appropriate master-detail triggers to enforce the coordination setting you choose.

Applies to:

relation

Set:

Oracle Forms, programmatically

Refer to Built-in

GET_RELATION_PROPERTY

SET_RELATION_PROPERTY

Default

Immediate coordination (Deferred No, Automatic Query No)

Usage Notes

Whenever the current record in the master block changes at runtime (a coordination-causing event), Oracle Forms needs to populate the detail block with a new set of records. You can specify exactly how and when that population should occur by setting this property to one of three valid settings:

Deferred=No,Auto Query ignored

The default setting. When a coordination-causing event occurs in the master block, the detail records are fetched immediately.

Deferred=Yes, Auto Query=Yes

When a coordination-causing event occurs, Oracle Forms defers fetching the associated detail records until the operator navigates to the detail block.

Deferred=Yes, Auto Query=No

When a coordination-causing event occurs, Oracle Forms defers fetching the associated detail records until the operator navigates to the detail block and explicitly executes a query.

Deferred=No,Auto Query=Yes

Not a valid setting.

Coordination Restrictions

The ability to set and get these properties programmatically is included only for applications that require a custom master-detail scheme. For a default master-detail relation created at design time, Oracle Forms generates the appropriate triggers to enforce coordination, and setting the coordination properties at runtime has no effect on the default trigger text.