Home » Developer & Programmer » Forms » how to manage many list items in forms 6i?
how to manage many list items in forms 6i? [message #275635] Mon, 22 October 2007 02:54 Go to next message
nadia74
Messages: 85
Registered: August 2007
Member
Hi,
I'd like to know how to manage many list items in forms 6i.
I have four list items connected to each other 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 code which stored in DB).

any ideas?
Regards
Re: how to manage many list items in forms 6i? [message #275844 is a reply to message #275635] Tue, 23 October 2007 00:59 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
For 'itm1' in 'blk1', create 'record_group' one which has an unqualified 'where' clause and is used in LOV1 which you associate with 'blk1.itm1'. For 'blk1.itm2', you create 'record_group' two which has 'table.column = :blk1.itm1' in its 'where' clause and is used by LOV2. Ditto for item 3, item 4, etcetera. If the table column you want to populate is numeric and the block item is character then use 'to_char' or 'to_number' in the 'select' statement of your record group.

David

Upd: Typos

[Updated on: Tue, 23 October 2007 01:00]

Report message to a moderator

Re: how to manage many list items in forms 6i? [message #275883 is a reply to message #275844] Tue, 23 October 2007 03:29 Go to previous messageGo to next message
nadia74
Messages: 85
Registered: August 2007
Member
Tanks for your reply.
but I wonder if i can do this without using LOV only by using list items.
Regards
Re: how to manage many list items in forms 6i? [message #276076 is a reply to message #275883] Tue, 23 October 2007 19:31 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I can't see how you will dynamically populate the list item.

What is the issue that is directing you towards a list item?

David
Re: how to manage many list items in forms 6i? [message #276194 is a reply to message #275883] Wed, 24 October 2007 06:06 Go to previous message
musman
Messages: 147
Registered: July 2007
Location: Lahore
Senior Member

http://www.orafaq.com/forum/?t=msg&th=87475&109173/

check this link it may be a bit helpful.Same discussion .

[Updated on: Wed, 24 October 2007 06:07]

Report message to a moderator

Previous Topic: How to trap this error FRM-40350
Next Topic: fetch whole records
Goto Forum:
  


Current Time: Wed Dec 07 03:04:40 CST 2016

Total time taken to generate the page: 0.30423 seconds