Answer / bighnaraj dalai

Pre-Query is Used For Doing Proper Validation Before Any Query Related Operation .
Example:=

DECLARE
V_Where VARCHAR2(50);
V_OrderBy VARCHAR(100);
BEGIN
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);
END;


Post-Query is Used For Doing The Tax After validation is complete


Example:=
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


Example:=
MESSAGE('Pre Insert Trigger Fired...');
MESSAGE(' ');
SELECT EmpIncr.NEXTVAL
INTO :EMPBLOCK.Empno
FROM SYS.DUAL;
: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 := bighnaraj.dalai@gmail.com

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.

What is the difference between SHOW_EDITOR and EDIT_TEXTITEM?

1 Answers  

---

can you convert or reverse engineer a fmx back to a fmb file?

0 Answers  

---

How can a break order be created on a column in an existing group?

1 Answers  

---

What is the "LOV of Validation" Property of an item? What is the use of it?

1 Answers  

---

HI in report builder am creating paramters.for that i have taken emp table from scott user . in deptnum am displaying distinct deptno.if i select dept 10 ,empnum drop down should display empno's of deptno 10. .if i select dept 20 ,empnum drop down should display empno's of deptno 20.for this wat i have to do.

2 Answers  

---

How do you call other Oracle Products from Oracle Forms?

1 Answers  

---

Whar are the different default triggers created when Master Deletes Property is set to Cascade?

1 Answers  

---

I want to learn the Oracle configurator(OracleApps)can any one tell best institutes in Hyderbad

2 Answers  

---

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

1 Answers   iFlex,

---

Where is the external query executed at the client or the server?

2 Answers   Wipro,

---

What is pop list?

2 Answers  

---

What is user exit.?

2 Answers   IBM, Synergy, Zensar,

---