OraFAQ Forum: Forms » oracle form (merged 2)

Home » Developer & Programmer » Forms » oracle form (merged 2)

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

oracle form (merged 2) [message #664371]

Fri, 14 July 2017 02:10

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..

Report message to a moderator

Re: oracle form [message #664373 is a reply to message #664371]

Fri, 14 July 2017 03:17

cookiemonster
Messages: 13975
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.

Report message to a moderator

Re: oracle form [message #664374 is a reply to message #664373]

Fri, 14 July 2017 04:09

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

Report message to a moderator

Re: oracle form [message #664375 is a reply to message #664374]

Fri, 14 July 2017 04:21

cookiemonster
Messages: 13975
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.

Report message to a moderator

Re: oracle form [message #664376 is a reply to message #664375]

Fri, 14 July 2017 04:22

cookiemonster
Messages: 13975
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.

Report message to a moderator

Previous Topic:	Forms 12c Cluster
Next Topic:	Function doesn't insert

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 13 14:17:25 CDT 2026