What is purpose and order of firing the following triggers- on fetch- on select

  
Showing Answers 1 - 5 of 5 Answers

Krishna Kumar Jha

  • Aug 24th, 2005
 

First on-select then on-fetch trigger is fired . 
On-select is used to open and execute database query. on-fetch can be used in conjunction with on-select to replace the processing that normally occur in execute query built in procedure

liz

  • Sep 13th, 2006
 

1)On select fires first.

On select fFires when Forms Developer would normally execute the open cursor, parse, and execute phases of a query, to identify

2)On fetch fires next

When a query is first opened, on-fetch fires immediately after the On-Select trigger fires, when the first records are fetched into the block. While the query remains open, fires again each time a set of rows must be fetched into the block.

  Was this answer useful?  Yes

Fires when Form Builder would normally execute the open cursor, parse, and execute phases of a query, to identify the records in the database that match the current query criteria.


FORM AND BLOCK LEVEL

EXAMPLE
IF Get_Application_Property(DATASOURCE) = 'DB2' THEN
  User_Exit ( 'Query' );
  IF Form_Failure OR Form_Fatal THEN
    ABORT_QUERY;
  END IF;
ELSE
  /*
  **  Perform the default Form Builder task of opening the query.
  */
  Select_Records;
END IF;

  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