What is a difference between pre-select and pre-query?

Answer Posted / chaudhry

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.

Is This Answer Correct ?    6 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?

587


I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

834


what is tripstop report?

1348


all steps of bitmap report?

1899


How to create Drill down report?

1683






in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

1284


from where do u receive the information to develop report

1521


what are the oracle forms services components include?

545


What is a matrix report and how many minimum groups are required to prepare the same?

538


I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object

2263


how do u compile a form i.e .fmb file in Unix or in dos

4011


difference between global n context sensitive segments?

2195


if u want to delete all these detail block etc what will happen in form

1465


Explain the different levels at which oracle form services interact.

595


i am writing a query select EmpNo from Emp how can i call in after parameter form

1589