Home » Developer & Programmer » Forms » showing LOV (Oracle form 9i)
showing LOV [message #382910] Mon, 26 January 2009 04:27 Go to next message
laith
Messages: 41
Registered: December 2008
Location: U.A.E
Member
I have 3 text items (city,zone_code,route_code), zone_code has LOV and route_code has LOV… I would like to know how to do if city has data so the zone_code show lov depend on the data in city but if the city is null so lov in the zone_code showing all the data that zone_code has.
Samething with route_code, the route_code has data depend on the data in city and zone_code, so if the city is null and zone_code has data , so route_code showing lov depend on just zone_code and the city has data and zone_code is null, so route_code showing lov depend on just city. Thank you guys for your support.
Re: showing LOV [message #382918 is a reply to message #382910] Mon, 26 January 2009 05:42 Go to previous messageGo to next message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
Write the SQL as you described. There's nothing difficult about that one.
Re: showing LOV [message #383013 is a reply to message #382910] Mon, 26 January 2009 23:54 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Create the 'record_group'. Create an 'LOV' using the 'record_group'. Create an item using the LOV. Update the LOV to point to the new item. That's pretty much it.

david
Previous Topic: JSP and Oracle forms and Jsp page from orcle form (merged)
Next Topic: How to find out the name of the Stored Procedures that are used in a form?
Goto Forum:
  


Current Time: Sat Dec 10 13:01:40 CST 2016

Total time taken to generate the page: 0.06798 seconds