ash s
asked on
why clear_list not clear the list in oracle form
here is my sample code.....please check what is wrong in this code why clear_list not clear the list before updating the list for second selection from drop-down....
DECLARE
CURSOR CUR_FURNACE_CAT_TYPE(F_TYP E IN CHAR) IS
SELECT FURNACE_TYPE,CAT_TYPE_DESC ,CAT_TYPE_ ID
from PRC_FURNACE_CAT_TYPE
WHERE FURNACE_TYPE=F_TYPE
order by CAT_TYPE_ID;
V_CNT NUMBER := 1;
BEGIN
CLEAR_LIST('PRC_HT_FURNACE .CATEGORY' );
IF :PRC_HT_FURNACE.FURNACE_TY PE='04' THEN
FOR LP IN CUR_FURNACE_CAT_TYPE('04') LOOP
ADD_LIST_ELEMENT('PRC_HT_F URNACE.CAT EGORY', V_CNT, LP.CAT_TYPE_DESC,LP.CAT_TY PE_ID);
V_CNT := V_CNT + 1;
END LOOP;
ELSIF :PRC_HT_FURNACE.FURNACE_TY PE='05' THEN
FOR LP IN CUR_FURNACE_CAT_TYPE('05') LOOP
ADD_LIST_ELEMENT('PRC_HT_F URNACE.CAT EGORY', V_CNT, LP.CAT_TYPE_DESC,LP.CAT_TY PE_ID);
V_CNT := V_CNT + 1;
END LOOP;
ELSIF :PRC_HT_FURNACE.FURNACE_TY PE='06' THEN
FOR LP IN CUR_FURNACE_CAT_TYPE('06') LOOP
ADD_LIST_ELEMENT('PRC_HT_F URNACE.CAT EGORY', V_CNT, LP.CAT_TYPE_DESC,LP.CAT_TY PE_ID);
V_CNT := V_CNT + 1;
END LOOP;
END IF;
END;
DECLARE
CURSOR CUR_FURNACE_CAT_TYPE(F_TYP
SELECT FURNACE_TYPE,CAT_TYPE_DESC
from PRC_FURNACE_CAT_TYPE
WHERE FURNACE_TYPE=F_TYPE
order by CAT_TYPE_ID;
V_CNT NUMBER := 1;
BEGIN
CLEAR_LIST('PRC_HT_FURNACE
IF :PRC_HT_FURNACE.FURNACE_TY
FOR LP IN CUR_FURNACE_CAT_TYPE('04')
ADD_LIST_ELEMENT('PRC_HT_F
V_CNT := V_CNT + 1;
END LOOP;
ELSIF :PRC_HT_FURNACE.FURNACE_TY
FOR LP IN CUR_FURNACE_CAT_TYPE('05')
ADD_LIST_ELEMENT('PRC_HT_F
V_CNT := V_CNT + 1;
END LOOP;
ELSIF :PRC_HT_FURNACE.FURNACE_TY
FOR LP IN CUR_FURNACE_CAT_TYPE('06')
ADD_LIST_ELEMENT('PRC_HT_F
V_CNT := V_CNT + 1;
END LOOP;
END IF;
END;
Where (in what trigger) is the provided code used ? Also you have to read Clear_list built-in in the Forms on-line help for usage notes and restriction.
ASKER
in when_list_changed trigger i used that code....
ASKER
that is Drop down list 2 which depends on the value that it is selected in Drop down list 1
somehow on list changed of Drop down list 1 i want the Drop down list 2 to be filtered.
i write drop down list 1 code in when new form instance......and drop down list 2 code in when_list_changed trigger.
somehow on list changed of Drop down list 1 i want the Drop down list 2 to be filtered.
i write drop down list 1 code in when new form instance......and drop down list 2 code in when_list_changed trigger.
ASKER
supposed i have 1st list the
A
B
C
if i select 'A'
then Second list show
1
2
3
and if i select B in 1 drop-down list
then 2nd list show
3
4
5
A
B
C
if i select 'A'
then Second list show
1
2
3
and if i select B in 1 drop-down list
then 2nd list show
3
4
5
ASKER
but in my code problem is that when i select A then it show result
1
2
3
and when i select B then it show
3
4
5
1
2
3
clear_list not clear the list.
1
2
3
and when i select B then it show
3
4
5
1
2
3
clear_list not clear the list.
If I understand it correctly there is 1st list - PRC_HT_FURNACE.FURNACE_TYP E and second PRC_HT_FURNACE.CATEGORY. Is there any error ?
Have you try only this code ?
BEGIN
CLEAR_LIST('PRC_HT_FURNACE .CATEGORY' );
END;
Have you try only this code ?
BEGIN
CLEAR_LIST('PRC_HT_FURNACE
END;
ASKER
yp, u understand correctly.............prob lem is that clear list not clear the 2 list before updating the 2 list depend on list 1.............
ASKER
i write whole above code(2nd drop down list code) in when_list_changed trigger and 1st drop down list code in when-new-form-instance.... ..
I am lost:
1st list - PRC_HT_FURNACE.FURNACE_TYP E - here is When-List-Changed trigger ?
2nd list - PRC_HT_FURNACE.CATEGORY
1st list - PRC_HT_FURNACE.FURNACE_TYP
2nd list - PRC_HT_FURNACE.CATEGORY
ASKER
no............
1st list - PRC_HT_FURNACE.FURNACE_TYP E -------------------code in when_new_form_instance
2nd list - PRC_HT_FURNACE.CATEGORY--- -----code in When-List-Changed trigger
1st list - PRC_HT_FURNACE.FURNACE_TYP
2nd list - PRC_HT_FURNACE.CATEGORY---
But When-list-changed trigger is on what item- PRC_HT_FURNACE.FURNACE_TYP E or PRC_HT_FURNACE.CATEGORY ?
ASKER
When-list-changed trigger is on PRC_HT_FURNACE.CATEGORY
ASKER
sorry When-list-changed trigger is on item- PRC_HT_FURNACE.FURNACE_TYP E
So it is the problem, because you cannot clear list item in its when-list-changed trigger. You can use your code e.g. in When-New-Record-Instance trigger of block PRC_HT_FURNACE and also in When-list-changed trigger on PRC_HT_FURNACE.FURNACE_TYP E.
According to your last post it ought to work. Have you try only clear_list and see what will happen ?
According to your last post it ought to work. Have you try only clear_list and see what will happen ?
ASKER
i used When-list-changed trigger on PRC_HT_FURNACE.FURNACE_TYP E but it still not clear the list
OK, try only this code
BEGIN
CLEAR_LIST('PRC_HT_FURNACE .CATEGORY' );
END;
BEGIN
CLEAR_LIST('PRC_HT_FURNACE
END;
ASKER
in which item trigger i used this code?
Please try it on When-List-Changed trigger on item PRC_HT_FURNACE.FURNACE_TYP E.
ASKER
if i only use this code then how i populate the list PRC_HT_FURNACE.CATEGORY... .......... .......
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.