Home » Developer & Programmer » Forms » how to manage many list items in forms 6i?
how to manage many list items in forms 6i? [message #297293] Thu, 31 January 2008 01:05 Go to next message
nadia74
Messages: 85
Registered: August 2007
Member
Hi,
I've tried to manage four list items relateed to each other
the countries,states,cities,areas. when i change the value in the first list the second list should populated with values related to the first list and the third list should populated with values related to the second list and so on.
The proplem is when doing this the list values changed from text to numeric (the value which stored in DB).

any ideas?
Regards
Re: how to manage many list items in forms 6i? [message #297316 is a reply to message #297293] Thu, 31 January 2008 02:07 Go to previous messageGo to next message
susantaindia
Messages: 12
Registered: January 2008
Location: India
Junior Member
You can try global variable with type casting.
Re: how to manage many list items in forms 6i? [message #297337 is a reply to message #297316] Thu, 31 January 2008 03:11 Go to previous messageGo to next message
nadia74
Messages: 85
Registered: August 2007
Member
Hi,
Thanks for your help, but can you explain it more to me.
Regards
Re: how to manage many list items in forms 6i? [message #297370 is a reply to message #297337] Thu, 31 January 2008 04:53 Go to previous messageGo to next message
susantaindia
Messages: 12
Registered: January 2008
Location: India
Junior Member
Hi,
Declare four global variable according to your required type and
assign values to those global variable on WHEN_LIST_CHANGED trigger and use those global variable to populate values to the next list item.
Regards
Re: how to manage many list items in forms 6i? [message #297474 is a reply to message #297370] Thu, 31 January 2008 22:00 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Forget GLOBALs. Look at http://www.orafaq.com/forum/m/286541/67467/?srch=four+LOV#msg_286541 and http://www.orafaq.com/forum/m/275844/67467/?srch=LOV+where#msg_275844

David
Re: how to manage many list items in forms 6i? [message #297530 is a reply to message #297474] Fri, 01 February 2008 04:18 Go to previous messageGo to next message
susantaindia
Messages: 12
Registered: January 2008
Location: India
Junior Member
Hi
I think you have not got my point.
I think it is possible to write a code like :global.xxx := to_char(1234) or :global.xxx := to_number('1234') and use those global variable for later purpose.
Regards
Re: how to manage many list items in forms 6i? [message #297580 is a reply to message #297293] Fri, 01 February 2008 08:05 Go to previous messageGo to next message
musman
Messages: 147
Registered: July 2007
Location: Lahore
Senior Member

i think this may be helpful.
i have user allowed modules stored as number in permissions table.
but in list i am showing modules name.
i think same you require country,city,etc
here is user,permission...
Re: how to manage many list items in forms 6i? [message #297585 is a reply to message #297293] Fri, 01 February 2008 08:52 Go to previous messageGo to next message
rajy_salim
Messages: 204
Registered: January 2008
Location: Beirut - Lebanon
Senior Member
What do you mean by :
Quote:
the list values changed from text to numeric (the value which stored in DB).


You may see the returning values . . .
Re: how to manage many list items in forms 6i? [message #297752 is a reply to message #297585] Sun, 03 February 2008 06:22 Go to previous messageGo to next message
nadia74
Messages: 85
Registered: August 2007
Member
Hi,
Thanks David for your help.
I've read what you've pointed to, but is there any way to do it only with lists without needing to LOV'S.
Regards,
Re: how to manage many list items in forms 6i? [message #297829 is a reply to message #297752] Sun, 03 February 2008 23:03 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I don't think so. You need the LOV to display the list. An LOV is associated with an item to catch the returned value. The 'list' which is actually a 'record group' can be shared by multiple LOVs and is NOT associated with an particular return item.

David
Previous Topic: Internet Explorer Problem While Accessing to Application Server
Next Topic: FRM-30409: Delete Record Behavior for the relation is invalid.
Goto Forum:
  


Current Time: Mon Dec 05 02:29:25 CST 2016

Total time taken to generate the page: 0.12170 seconds