Home » Developer & Programmer » Forms » Changing LOV based on some other text item (Oracle Forms 10g)
Changing LOV based on some other text item [message #582502] Thu, 18 April 2013 21:33 Go to next message
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.
Re: Changing LOV based on some other text item [message #582505 is a reply to message #582502] Thu, 18 April 2013 22:43 Go to previous messageGo to next message
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.
Re: Changing LOV based on some other text item [message #582513 is a reply to message #582505] Fri, 19 April 2013 00:39 Go to previous message
Littlefoot
Messages: 19516
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).
Previous Topic: Uploading an excel file using webutil in AIX
Next Topic: displaying own menus instead of default menu
Goto Forum:
  


Current Time: Thu Aug 28 04:40:26 CDT 2014

Total time taken to generate the page: 0.17603 seconds