Home » Developer & Programmer » Forms » List item problem
List item problem [message #541234] Mon, 30 January 2012 03:04 Go to next message
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/

Please help...
  • Attachment: error.PNG
    (Size: 4.91KB, Downloaded 1010 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
cookiemonster
Messages: 13926
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.
Previous Topic: visual attribute
Next Topic: login page value disappear when i enter 2nd record (merged 2)
Goto Forum:
  


Current Time: Mon Jul 15 15:10:57 CDT 2024