OraFAQ Forum: Forms » default value for dropdown list box

Home » Developer & Programmer » Forms » default value for dropdown list box

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

default value for dropdown list box [message #145001]

Mon, 31 October 2005 00:15

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

Report message to a moderator

Re: default value for dropdown list box [message #145078 is a reply to message #145001]

Mon, 31 October 2005 15:02

Frank Naude
Messages: 4589
Registered: April 1998

Senior Member

Are you working with Oracle Forms? Give us some hints!

Report message to a moderator

Re: default value for dropdown list box [message #145129 is a reply to message #145078]

Tue, 01 November 2005 00:47

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

Report message to a moderator

Re: default value for dropdown list box [message #145393 is a reply to message #145129]

Wed, 02 November 2005 17:29

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: default value for dropdown list box [message #294507 is a reply to message #145129]

Thu, 17 January 2008 18:08

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 00:09:50 CST 2025