When is PRE-QUERY trigger executed ?
Answers were Sorted based on User's Feedback
Answer / guest
When Execute-query or count-query Package procedures are invoked
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / dinesh mohan upadhyay
pre query is executed fefore user goes to input.
it execute only one time for any block
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ravi
This trigger executes before the input goes into to any data
or control block. This trigger will execute only once when
data block gets input focus.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are Most Common types of Complex master-detail relationships?
How do you pass the parameters from one form to another form?
What are the default extension of the files created by library module?
What the PAUSE package procedure does ?
What is lexical reference?How can it be created?
i have 9 values in a table i.e -99 -56 -32 41 -2 33 95 -88 55 my question is that i wanna elimenate all -ve values and wann sum of + values in report i m using devsuite 10g its urgent kindly if anyone knows that answer message me the following yahoo id thanx ALI smalipaki@yahoo.com
did u p prepared complex report
Is the After report trigger fired if the report execution fails?
Any attempt to navigate programatically to disabled form in a call_form stack is allowed?
Whar are the different default triggers created when Master Deletes Property is set to Cascade?
i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE
plz explain when we are using pre-query,post-query,pre-insert and post-insert?plz explain with one example