Home » Developer & Programmer » Forms » LOV - Select statement
LOV - Select statement [message #79896] Mon, 22 July 2002 05:57 Go to next message
Vani Viswanathan
Messages: 4
Registered: July 2002
Junior Member
Hi,

I have an LOV for displaying model no: which is an user parameter in a report. The list of valid values for the LOV is displayed with a SELECT statement. The user must also be able to say - 'display info for all the model no:s available'. For this functionality, the LOV must show 'ALL' in its drop down list. How to accomplish this ?

Thanks in advance

Vani Viswanathan.

Report message to a moderator

Re: LOV - Select statement [message #79897 is a reply to message #79896] Mon, 22 July 2002 06:25 Go to previous message
N
Messages: 26
Registered: April 2002
Junior Member
select 'All' from dual;
UNION
select 'Only ONE' from dual;

Report message to a moderator

Previous Topic: How to display the current date in the Text Field programmetically
Next Topic: how can i use array in form6.0 or in oracle 8i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 22:39:18 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.