Home » Oracle » 1z0-151 » What must you do to achieve this?
You have written a When-Validate-ltem trigger. You want this trigger to fire even if the form is in Enter-Query mode. What must you do to achieve this?
A. Use the following code at the start of the When Validate-ltem trigger:
:SYSTEM.mode := ‘ENTER-QUERY’;
B. Use the following code at the start of the When Validate Item trigger:
:SYSTEM.mode := ‘NORMAL’;
C. Set the Fire in Enter Query Mode property of the When-Validate-ltem trigger.
D. You do not need to do anything, because the default for the When Validate Item trigger is to fire in Enter-Query mode.
E. You cannot achieve this, because the When-Validate-ltem trigger cannot be set to fire in Enter-Query mode.
Correct Answer: E
Explanation/Reference:
Explanation:
Coding Triggers for Enter-Query Mode
Some triggers that fire when the form is in Normal mode (during data entry and saving) may also be fired in Enter-Query mode. You need to consider the trigger type and actions in these cases.
“Fire in Enter-Query Mode”Property
To create a trigger that fires in Enter-Query mode, in its Property Palette set the “Fire in Enter-Query Mode”property to Yes. This property determines whether
Forms fires a trigger if the associated event occurs in Enter-Query mode. Not all triggers can do this. See last line in note below.
By default, the “Fire in Enter-Query Mode”property is set to Yes for triggers that accept this. Set it to No in the Property Palette if you want the trigger to fire only in Normal mode.
Note:
The following triggers may fire in Enter-Query mode:
*Key-
* On-Error
* On-Message
* When-triggers, except:
-When-Database-Record
-When-Image-Activated
-When-New-Block-Instance
-When-New-Form-Instance
-When-Create-Record
-When-Remove-Record
-When-Validate-Record
-When-Validate-Item
|
Download Printable PDF. VALID exam to help you PASS.
|
 |
