Part-22

What is WHEN-Database-record trigger? -
Fires when oracle forms first marks a record as an insert or an update. The trigger fires as soon as oracle forms determines through validation that the record should be processed by the next post or commit as an insert or update. Generally occurs only when the operators modifies the first item in the record, and after the operator attempts to navigate out of the item.

What is a difference between pre-select and pre-query? -
Fires during the execute query and count query processing after oracle forms constructs the select statement to be issued, but before the statement is actually issued. The pre-query trigger fires just before oracle forms issues the select statement to the database after the operator as define the example records by entering the query criteria in enter query mode. Pre-query trigger fires before pre-select trigger.


What are built-ins associated with timers? -
find_timer ,create_timer, delete_timer

What are the built-ins used for finding Object ID function? -
FIND_GROUP(function) FIND_COLUMN(function)


Any attempt to navigate programmatically to disabled form in a call_form stack is allowed? - False


Use the Add_group_row procedure to add a row to a static record group 1. true or false? - False


Use the add_group_column function to add a column to record group that was created at a design time? - False


What are the various sub events a mouse double click event involves? -
Double clicking the mouse consists of the mouse down, mouse up, mouse click, mouse down & mouse up events.


How can a break order be created on a column in an existing group? - By dragging the column outside the group.


What is the use of place holder column? - -
A placeholder column is used to hold calculated values at a specified place rather than allowing is to appear in the actual row where it has to appear.


What is the use of hidden column?
A hidden column is used to when a column has to embed into boilerplate text.


What is the use of break group? -
A break group is used to display one record for one group ones. While multiple related records in other group can be displayed.


What is an anchoring object & what is its use? -
An anchoring object is a print condition object which used to explicitly or implicitly anchor other objects to itself.


What are the various sub events a mouse double click event involves? -
Double clicking the mouse consists of the mouse down, mouse up, mouse click, mouse down & mouse up events.


What are the default parameter that appear at run time in the parameter screen? - Destype and Desname.


What are the built-ins used for Creating and deleting groups? - CREATE-GROUP (function) CREATE_GROUP_FROM_QUERY(function) DELETE_GROUP(procedure)


What are different types of canvas views? -Content canvas views Stacked canvas views Horizontal toolbar vertical toolbar.


What are the different types of Delete details we can establish in Master-Details? - Cascade Isolate Non-isolate