Oracle Exam 1Z0-151 Topic 8 Question 12 Discussion

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