Multiple choice

JOHN is running a multiple-form application. The Customers Form invoked the Orders Form. When the Orders Form launches, it displays orders for only the active customer from the Customers form. Forms exchange data with the GLOBAL.CUSTOMER_ID variable. The Orders Form should be restricted to the orders for the current customer only when the query is issued for the first time after invoking the Orders form. Which built-in helps him do this by setting the ONETIME_WHERE property to refer dynamically to the GLOBAL.CUSTOMER_ID?

  1. SET_APPLICATION_PROPERTY

  2. SET_FORM_PROPERTY

  3. SET_BLOCK_PROPERTY

  4. SET_RECORD_PROPERTY

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

SET_BLOCK_PROPERTY is the correct built-in because ONETIME_WHERE is a block-level property in Oracle Forms that restricts a query to execute only once when the block is first queried. SET_APPLICATION_PROPERTY operates at application level, SET_FORM_PROPERTY at form level, and SET_RECORD_PROPERTY at individual record level - none of these can set the ONETIME_WHERE clause which belongs to the block's WHERE clause behavior.