OraFAQ Forum: Forms » Changing LOV based on some other text item

Home » Developer & Programmer » Forms » Changing LOV based on some other text item (Oracle Forms 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Changing LOV based on some other text item [message #582502]

Thu, 18 April 2013 21:33

amit1cs
Messages: 2
Registered: April 2013
Location: United States

Junior Member

Hello All,

I got a required to show LOV or list ... based on some value in other column. Let me explain ... suppose in column A has value is A1 then column B should show A11, A12 , A13 and if Column A has value C then cloumn B should show C11, C12 ... etc//

Please suggest.

Thanks.

Report message to a moderator

Re: Changing LOV based on some other text item [message #582505 is a reply to message #582502]

Thu, 18 April 2013 22:43

amit1cs
Messages: 2
Registered: April 2013
Location: United States

Junior Member

I see some post that set_item_property and show_lov can be helpful ... but I can not use them.

Report message to a moderator

Re: Changing LOV based on some other text item [message #582513 is a reply to message #582505]

Fri, 19 April 2013 00:39

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

All you need is the appropriate WHERE clause.

select some_column
from your_table
where substr(some_column, 1, 1) = :block.column_A

That might need to be modified to suit your data model (but, as you didn't post tables' description, values stored within, the above code is just a general guideline).

Report message to a moderator

Previous Topic:	Uploading an excel file using webutil in AIX
Next Topic:	displaying own menus instead of default menu

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 00:38:04 CDT 2024