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.

bc_sumanamara

 Profile Answers by bc_sumanamara 

• Jan 12th, 2009

 

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;