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
Default
Immediate coordination (Deferred No, Automatic Query No)
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. |
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.