A Critical problem faced . [message #85774] |
Wed, 28 July 2004 05:40 |
domingo
Messages: 54 Registered: June 2004
|
Member |
|
|
well !
I need to clear the block when i change the value for the query item .
suppose i have textbox1 i put a value on it anf then execute query . i need to clear all the aother text boxes when i change value of textbox 1 .
do let me know if u hav any doubt ..
its urgent plzz help
thanks
domingo
|
|
|
Re: A Critical problem faced . [message #85809 is a reply to message #85774] |
Sat, 31 July 2004 00:53 |
MNRaju
Messages: 6 Registered: July 2004
|
Junior Member |
|
|
Hi,
Assume you have EMP block (source is EMP table) and EMPNO is the queryble item. After retrieving record(s), if the user changes EMPNO of any retrieved record then all other fields should be cleared automatically.
Use the following code in WHEN-VALIDATE-ITEM trigger of EMPNO field to satisfy the above condition.
DECLARE
V_EMPNO NUMBER(4):=NULL;
BEGIN
IF :SYSTEM.RECORD_STATUS = 'CHANGED' THEN
IF GET_ITEM_PROPERTY('EMP.EMPNO', DATABASE_VALUE) <> :EMP.EMPNO THEN
:EMP.ENAME := NULL;
:EMP.JOB := NULL;
:EMP.MGR := NULL;
:EMP.HIREDATE := NULL;
:EMP.SAL := NULL;
:EMP.COMM := NULL;
:EMP.DEPTNO := NULL;
END IF;
END IF;
END;
|
|
|
|