Validate From List Property
Description
Specifies whether Oracle Forms should validate the value of the text item against the values in the attached LOV.
Applies to text item
Set Oracle Forms
No
Required/Optional optional
Restrictions:
List of Values property must be specified.
Usage Notes
When Validate from List is Yes, Oracle Forms compares the current value of the text item to the values in the first column displayed in the LOV whenever the validation event occurs:
- If the value in the text item matches one of the values in the first column
of the LOV, validation succeeds, the LOV is not displayed, and processing
continues normally.
- If the value in the text item does not match one of the values in the first
column of the LOV, Oracle Forms displays the LOV and uses the text item
value as the search criteria to automatically reduce the list.
- For example, if the operator enters the first three digits of a 6-digit
product code and then tries to navigate to the next item, Oracle Forms
displays the LOV and auto-reduces the list to display all of the codes that
have the same first three digits.
- If the operator selects a value from the LOV, Oracle Forms dismisses
the LOV and assigns the selected values to their corresponding return items.
- When you use an LOV for validation, Oracle Forms generally marks a text
item as Valid if the operator selects a choice from the LOV. Thus, it is your
responsibility to ensure that:
- the text item to which the LOV is attached is defined as a return item
for the first column displayed in the LOV and
- the values in the LOV are valid
However, when a When-Validate-Item trigger on the item still fires, any
validation checks you perform in the trigger still occur.
Also, the first column displayed in the LOV may not be the first column
in the LOV's underlying record group, as some record group columns may not
have been included in the LOV structure, or may be hidden columns.
Related topics
About attaching LOVs to text
items