RE: What is purpose and order of firing the following triggers- on fetch- on select
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
RE: What is purpose and order of firing the following ...
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.
RE: What is purpose and order of firing the following triggers- on fetch- on select
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;