GeekInterview.com
Series: Subject: Topic:
Question: 74 of 74

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

Asked by: Interview Candidate | Asked on: Aug 24th, 2005
Showing Answers 1 - 3 of 3 Answers
Krishna Kumar Jha

Answered On : 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

Yes  1 User has rated as useful.
  
Login to rate this answer.
liz

Answered On : 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.

  
Login to rate this answer.
bc_sumanamara

Answered On : Jan 12th, 2009

View all answers by bc_sumanamara

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;

  
Login to rate this answer.

Give your answer:

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

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.