Page 34 of 95
A piece of logic that is executed at or triggered by a SQL *forms
event.
9. What are the types of TRIGGERS ?
1. Navigational Triggers.
2. Transaction Triggers.
10. What are the different types of key triggers ?
Function Key
Key-function
Key-others
Key-startup
11. What is the difference between a Function Key Trigger and Key
Function Trigger ?
Function key triggers are associated with individual SQL*FORMS
function keys
You can attach Key function triggers to 10 keys or key sequences
that normally do not perform any SQL * FORMS operations. These keys
refered as key F0 through key F9.
12. What does an on-clear-block Trigger fire?
It fires just before SQL * forms the current block.
13. How do you trap the error in forms 3.0 ?
using On-Message or On-Error triggers.
14. State the order in which these triggers are executed ?
POST-FIELD,ON-VALIDATE-FIELD,POST-CHANGE and KEY-NEXTFLD.
KEY-NEXTFLD,POST-CHANGE, ON-VALIDATE-FIELD, POST-FIELD.
15. What is the usuage of an ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS
?
These triggers are executes when inserting,deleting and updating
operations are performed and can be used to change the
default function of insert,delete or update respectively.
For Eg, instead of inserting a row in a table an existing row
can be updated in the same table.
16. When will ON-VALIDATE-FIELD trigger executed ?
It fires when a value in a field has been changed and the field
status is changed or new and the key has been pressed. If the
field status is valid then any further change to the value in the
field will not fire the on-validate-field trigger.
|
|