Home » Developer & Programmer » Forms » default value for dropdown list box
default value for dropdown list box [message #145001] Mon, 31 October 2005 00:15 Go to next message
liushuo12
Messages: 7
Registered: October 2005
Location: Wollongong, Australia
Junior Member
Hi, all
I want to find a sample to send up a drop down list box with
default value null->"select" at the top

could any one give me the hints?

thx ahead

shuo
Re: default value for dropdown list box [message #145078 is a reply to message #145001] Mon, 31 October 2005 15:02 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Are you working with Oracle Forms? Give us some hints!
Re: default value for dropdown list box [message #145129 is a reply to message #145078] Tue, 01 November 2005 00:47 Go to previous messageGo to next message
liushuo12
Messages: 7
Registered: October 2005
Location: Wollongong, Australia
Junior Member
I am establishing a form with oracle to create a new entity.

the value of one attribute of that entity will be displayed in the drop down list box coming from a table.

The default value (null) with 'selected' is asked to display at the top of the drop down list box.

thanks advance

shuo
Re: default value for dropdown list box [message #145393 is a reply to message #145129] Wed, 02 November 2005 17:29 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Build your record group using the standard select for the data using a third column for sorting and UNION that data select with a NULL, NULL, '1' from DUAL select. ORDER it by 3,1

David
Re: default value for dropdown list box [message #294507 is a reply to message #145129] Thu, 17 January 2008 18:08 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I expect that you have moved on from this problem but I saw this entry in metalink today and I want to have the reference to it as part of a meaningful thread.

"How To Put An NULL Value At The Top of a Poplist Instead of At The Bottom" Note:467661.1 This points to "How to Change the Navigation Order in a Pop List?" Note:1011765.102

David
Previous Topic: Oracle Form Error in Browser
Next Topic: Migrate form 6i to form9i
Goto Forum:
  


Current Time: Sun Dec 04 13:05:25 CST 2016

Total time taken to generate the page: 0.12455 seconds