This preview shows page 1. Sign up to view the full content.
Unformatted text preview: ance trigger.
B. In a Pre-Query trigger on the Orders block.
C. In a When-Create-Record trigger on the Orders block.
D. In a When-New-Record-Instance trigger on the Orders block.
You are 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 orders for the current customer only the first time a query is issued after
invoking the Orders form.
Which built-in helps you to do this by setting the ONETIME_WHERE property to refer dynamically to the
You need to restrict access to a form. Access must be limited to a particular times of day and to certain
You write a procedure (get_authorization) in the form that checks the username of the person logging in and
Actualtests.com - The Power of Knowing 1Z0-141
validates the time of day. If the person is not authorized to use the form at that time, the following code is
('You are not authorized to access the form at this time');
What is the best trigger from which to call this procedure? Why?
A. When-Validate-Item on the first enterable item, because the form will exit without showing the position of
fields on the screen or the accompanying prompts.
B. Pre-Text-Item on the first navigable text item in the first navigable block, because this will trap every user
and allow time for the message to be read before exiting the form.
C. When-New-Form-Instance at form level, because GET_AUTHORIZATION is a restricted procedure and
cannot be called from any "Pre" trigger.
D. Pre-Form at form level, because the form will exit immediately after displaying the message in an alert.
View Full Document
- Fall '09