List item problem [message #541234] |
Mon, 30 January 2012 03:04 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](//www.gravatar.com/avatar/c84b9586eeb721a1c63c0fcc5ee0b864?s=64&d=mm&r=g) |
aallan
Messages: 150 Registered: October 2011
|
Senior Member |
|
|
Dear All,
How are you ?
I have 2 list items, i populate first one by:
Declare
vr_record_group RECORDGROUP;
vn_populate Number;
Begin
If :Blk_1.Tech_Type = 1 Then
vr_record_group := Create_Group_From_Query('Tech_Subject','Select Decode(:Global.Language, 1, Dtl_Class_Desc_Ntv, Dtl_Class_Desc_Frn),
To_Char(Class_Serial)
From Dd_Classes_Dtl
Where Class_Code = 26
And Class_Serial In (1, 2, 3, 4)');
vn_populate := Populate_Group(vr_record_group);
Populate_List('Blk_1.Tech_Subject','Tech_Subject');
Elsif :Blk_1.Tech_Type = 2 Then
vr_record_group := Create_Group_From_Query('Tech_Subject','Select Decode(:Global.Language, 1, Dtl_Class_Desc_Ntv, Dtl_Class_Desc_Frn),
To_Char(Class_Serial)
From Dd_Classes_Dtl
Where Class_Code = 26
And Class_Serial In (5, 6, 7, 8, 9, 10, 11, 12, 13)');
vn_populate := Populate_Group(vr_record_group);
Populate_List('Blk_1.Tech_Subject','Tech_Subject');
End If;
End;
and when i change the value from list No. 1 in second or 3rd and so one...it gave me this error:
![/forum/fa/9759/0/](/forum/fa/9759/0/)
Please help...
-
Attachment: error.PNG
(Size: 4.91KB, Downloaded 1086 times)
[Updated on: Mon, 30 January 2012 03:39] by Moderator Report message to a moderator
|
|
|
Re: List item problem [message #541254 is a reply to message #541234] |
Mon, 30 January 2012 03:51 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
cookiemonster
Messages: 13963 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
I'd stop trying to use dynamic list items, there's all sorts of issues that make it unworkable.
Main one being that you can't change the list once a value has been selected unless that value is also in the new set of values for the list. Which looks unlikely from your queries.
Just use text items with LOVs instead.
|
|
|