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

Automatic Refresh Property

Description

Determines whether Oracle Forms re-executes the query to populate an LOV that is based on a query record group. By default, Oracle Forms executes the query to populate an LOV's underlying record group whenever the LOV is invoked; that is, whenever the LOV is displayed, or whenever Oracle Forms validates a text item that has the Use LOV for Validation property set to Yes.

The Automatic Refresh property also determines how long records retrieved by the query remain stored in the underlying record group:

Applies to LOV

Set Oracle Forms, programmatically

Refer to Built-in

GET_LOV_PROPERTY

SET_LOV_PROPERTY

Default

Yes

Usage Notes

Automatic Refresh Restrictions

Valid only for an LOV based on a query record group, rather than a static or non-query record group.