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
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;
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;
Oracle Database
Last Comment
Mark Geerlings
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
Have you try only this code ?
BEGIN
CLEAR_LIST('PRC_HT_FURNACE
END;
Have you try only this code ?
BEGIN
CLEAR_LIST('PRC_HT_FURNACE
END;
ASKER
yp, u understand correctly.............prob
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
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
2nd list - PRC_HT_FURNACE.CATEGORY---
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
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
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
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
OK, try only this code
BEGIN
CLEAR_LIST('PRC_HT_FURNACE
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
ASKER
if i only use this code then how i populate the list PRC_HT_FURNACE.CATEGORY...
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.