Home » Developer & Programmer » Forms » oracle form (merged 2)
oracle form (merged 2) [message #664371] Fri, 14 July 2017 02:10 Go to next message
deepaknegi
Messages: 2
Registered: June 2017
Junior Member
hey help me in creating a form
there is three list item country , state and city

if i select INDIA as a country then i want only INDIAN states in state_list, and if i select gujrat as a state then i want only gujrat's city in city_list....

and so on if i will select china , usa , japan...

if possible please upload a form..
Re: oracle form [message #664373 is a reply to message #664371] Fri, 14 July 2017 03:17 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
You don't want to use list items for this. It won't work because when you execute a query, if the column values of the record you're trying to retrieve don't match the values the corresponding list item is currently set to recognise then it'll silently fail to display the record.
So if the list items are set to India/Gujrat then you won't be able to query records belonging to any other country or state.

Basically dynamic list items just don't work. Use LOV's instead.
Re: oracle form [message #664374 is a reply to message #664373] Fri, 14 July 2017 04:09 Go to previous messageGo to next message
deepaknegi
Messages: 2
Registered: June 2017
Junior Member
HELLO SIR I KNOW ABOUT LOV BUT
SOMEONE SAYS TO ME ABOUT LIST ITEM...

ARE U SURE THIS IS NOT POSSIBLE
Re: oracle form [message #664375 is a reply to message #664374] Fri, 14 July 2017 04:21 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
I'm sure it'll behave the way I described. Why don't you point that out to the person who suggested the list items and see if they know a way round it - if they do I'd love to know what it is.
Re: oracle form [message #664376 is a reply to message #664375] Fri, 14 July 2017 04:22 Go to previous message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
And please don't post in all caps. That is considered as shouting on all internet forums.
Previous Topic: Forms 12c Cluster
Next Topic: Function doesn't insert
Goto Forum:
  


Current Time: Thu Mar 28 13:27:53 CDT 2024