Page 35 of 95
17. A query fetched 10 records How many times does a PRE-QUERY Trigger
and POST-QUERY Trigger will get executed ?
PRE-QUERY fires once.
POST-QUERY fires 10 times.
18. What is the difference between ON-VALIDATE-FIELD trigger
and a POST-CHANGE trigger ?
When you changes the Existing value to null, the On-validate field
trigger will fire post change trigger will not fire. At the time of
execute-query post-chage trigger will fire, on-validate field trigger
will not fire.
19. What is the difference between an ON-VALIDATE-FIELD trigger
and a trigger ?
On-validate-field trigger fires, when the field Validation status
New or changed.
Post-field-trigger whenever the control leaving form the field, it
will fire.
20. What is the difference between a POST-FIELD trigger and a POST-
CHANGE trigger ?
Post-field trigger fires whenever the control leaving from the filed.
Post-change trigger fires at the time of execute-query procedure
invoked or filed validation status changed.
21. When is PRE-QUERY trigger executed ?
When Execute-query or count-query Package procedures are invoked.
22. Give the sequence in which triggers fired during insert
operations, when the following 3 triggers are defined at the smae block
level ?
a. ON-INSERT b. POST-INSERT c. PRE-INSERT
PRE-INSERT,ON-INSERT & POST-INSERT.
23. Can we use GO-BLOCK package in a pre-field trigger ?
No.
24. Is a Keystartup trigger fires as result of a operator pressing a
key explicitly ?
No.
25. How can you execute the user defined triggers in forms 3.0 ?
Execute_Trigger (trigger-name)
26. When does an on-lock trigger fire ?
It will fires whenever SQL * Forms would normally attempt to lock a
row.
|
|