What does an on-clear-block Trigger fire?

 It fires just before SQL * forms the current block.

Showing Answers 1 - 5 of 5 Answers

mukts

  • Mar 31st, 2006
 

Perform an action whenever Oracle Forms flushes the current block; that is, removes all records from the block.

  Was this answer useful?  Yes

Dear Mukts,

As per my knowledge, no such trigger exists at Block Level. here are the list of On-triggers
On-Check-Delete-Master
On-Check-Unique
On-Clear-Details
On-Close
On-Column-Security
On-Commit
On-Count
On-Delete
On-Error
On-Fetch
On-Insert
On-Lock
On-Logon
On-Logout
On-Message
On-Populate-Details
On-Rollback
On-Savepoint
On-Select
On-Sequence-Number
On-Update

  Was this answer useful?  Yes

priyank74

  • Aug 30th, 2006
 

Dear Kamesh,You are correct, that current versions do not have it. But it seems to be true for older version 3.0 probably, please check the link :support.avaya.com/edoc/docs/convrnst/cnv5dsgn.pdfPlease correct me, if it's not.

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions