plz explain when we are using
pre-query,post-query,pre-insert and post-insert?plz explain
with one example
Answers were Sorted based on User's Feedback
Pre-Query is Used For Doing Proper Validation Before Any Query Related Operation .
V_Where := 'Deptno = '||:CONTROLBLOCK.QUERYDEPT;
V_OrderBy := :CONTROLBLOCK.DATASORTGROUP||' '||:CONTROLBLOCK.SORTORDERGROUP;
SET_BLOCK_PROPERTY ('EMPBLOCK', DEFAULT_WHERE, V_Where);
SET_BLOCK_PROPERTY ('EMPBLOCK', ORDER_BY, V_OrderBy);
Post-Query is Used For Doing The Tax After validation is complete
INSERT INTO SCOTT.QueryAudit@ORCL
VALUES(1, USER, USERENV('TERMINAL'), TO_DATE(TO_CHAR(SYSDATE, 'DD-MON-YYYY'), 'DD-MON-YYYY'), TO_DATE(TO_CHAR(SYSDATE, 'HH:MI:SS'), 'HH:MI:SS'));
Pre-Insert is doing the tax before insert into the database
MESSAGE('Pre Insert Trigger Fired...');
:GLOBAL.GENEmpno := :EMPBLOCK.Empno;
Post-Insert is Fired After The Data Insert Into The database
The Pre-insert And Post-Insert Helps For No Null Value Taken Even We Take Any Sequence In my Coading Because If There is no Proper validation Then The Raise Form_Trigger_Failure Trigger Terminate The Application
Hiiii friend if you Want To Take The .FMB File For This Program Or any Related Query Then Contact To Me
My Email_Id := email@example.com
|Is This Answer Correct ?||3 Yes||0 No|
Answer / sudipta santra
PRE-QUERY: BEFORE PARSING OF QUERY THIS TRIGGER IS FIRED.
POST-QUERY: AFTER PARSING OF THE QUERY AND BEFORE POST TO
THE DB, IT IS FIRED.
NOTE: THE VALUE CAN BE CHANGED AFTER FIRING PRE-QUERY BUT
THE VALUE CAN NOT BE CHANGED AFTER FIRING POST-QUERY.
PRE-INSERT: BEFORE INSERT IN THE DATA-BLOCK, IT IS FIRED.
POST-INSERT: AFTER INSERT INTO THE DATA BLOCK AND BEFORE
POST INTO THE DB IT IS FIRED.
NOTE: THE VALUE CAN BE CHANGED IN PRE-INSERT BUT NOT
POSSIBLE IN POST-INSERT.
|Is This Answer Correct ?||2 Yes||0 No|
How do you create a new session while open a new form?
What is a Layout Editor?
What is the sequence the Report triggers will fires while running a report ?
Is it possible to attach same library to more than one form?
hiding item in report how like that properly,thats manually but at runtime i want to do
.fmb will be in which folder
What is the usage of the confine mode in Layout Editor ?
What is a list item?
Name of the functions used to get/set canvas properties?
To execute row from being displayed that still use column in the row which property can be used?
what is the use of between page trigers in REPORTS... (please give answer in a explanatory way...if possible give screen shots also...)
List the Types of Items?