Select the use constraint property is ON Block definition screen. BLOCK
Latest Answer : We control the constraints in forms while selecting primary key 'yes' in property palett. ...
False.
It fires just before SQL * forms the current block.
Latest Answer : that master detail trigger name is on-clear-details. so this trigger does not exist atleast in 6 and above versions. don'y know abt lower versions ...
POST-FIELD,ON-VALIDATE-FIELD,POST-CHANGE and KEY-NEXTFLD.KEY-NEXTFLD,POST-CHANGE, ON-VALIDATE-FIELD, POST-FIELD.
Latest Answer : ON-VALIDATE-FIELD -> KEY-NEXTFLD -> POST-FIELD -> POST-CHANGE ...
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
Latest Answer : on-validate field tigger will fire when ever cursor moves from that field to next field, so first key-next will fire then validate. ...
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-change trigger will fire,
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
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.
Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
a. ON-INSERT b. POST-INSERT c. PRE-INSERT PRE-INSERT,ON-INSERT & POST-INSERT.
No.
Latest Answer : No, we cann't use go_block in pre_field trigger ...
