Multiple choice

The user must be able to invoke a list of values for valid sales representative in the Orders form. To facilitate this, a button was created and positioned next to the Sales Rep ID field The text item has these properties set:

  • Required: Yes

    - List of Values: SALES_REP_LOV

    - Validate from List: No

    The button has these properties set:

    - Keyboard Navigable: Yes

    -Mouse Navigate :Yes

    - Iconic :Yes

    - Icon Filename :list .ico

An appropriate LOV (called SALES_REP_LOV) was created and associated with the text item. An icon file (list.gif) exists in the appropriate directory. All other properties are left at their defaults. A When-Button-Pressed trigger was written at the item level with this code:

LIST_VALUES;

To test the form, it was attempted to enter a new record. What is the run-time behavior of the form?

  1. The form doesn't compile and therefore cannot be tested.

  2. The icon is not displayed on the button. When the Sales Rep Id field is clicked and then the button is clicked, the LOV is invoked.

  3. The icon is displayed on the button. When the Sales Rep Id field is clicked and then the button is clicked, the LOV is not invoked and an error is reported.

  4. The icon is not displayed on the button. When the Sales Rep Id field is clicked and then the button is clicked, the LOV is not invoked and an error is reported.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The icon filename property contains 'list .ico' with a space before the extension, but the actual file is 'list.gif' - this mismatch prevents icon display. The LIST_VALUES built-in requires the LOV to be associated with the currently focused item, but the button click shifts focus away from the text item, causing an error. This is a common Oracle Forms pitfall - the code would work if called via KEY-LISTVAL trigger or if LOV was properly validated.

Keep practicing — related questions