Answered Questions

  • What does an on-clear-block Trigger fire?

     It fires just before SQL * forms the current block.

    prachi

    • Sep 13th, 2006

    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

    Parimala

    • Sep 5th, 2006

    Hi, on-clear-block Trigger is an master detail trigger when Master-detail relation block is created and when the master block is cleared, on-clear-block trigger will fire and its functionality is dependent upon the Co-ordination properties of Master-detail block.

  • What is the difference between a Function Key Trigger and Key Function Trigger ?

     Function  key  triggers  are  associated with individual SQL*FORMS function keysYou  can  attach  Key  function  triggers  to 10 keys or key sequences that normally  do  not perform any SQL * FORMS operations. These keys referred as key F0 through key F9.