OraFAQ Forum: Forms » please help

Home » Developer & Programmer » Forms » please help

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

please help [message #385760]

Tue, 10 February 2009 23:29

charuamit
Messages: 121
Registered: January 2009

Senior Member

Hi friends

I have a LOV with the query 'select dp_name from table'

as per the department selected, i m displaying the records for the selected departments.

Now i also want to include an elment 'ALL' in my LOV so as to display the records for all the departments.

How can i do that ?
please help me.

Thanks in advance.

Charu.

Report message to a moderator

Re: please help [message #385771 is a reply to message #385760]

Wed, 11 February 2009 00:08

amit_yadav
Messages: 11
Registered: January 2009
Location: India

Junior Member

Dear Charu,

You can modify the query for your lov as:

SELECT 'All' dp_name FROM DUAL
UNION
SELECT dp_name FROM TABLE

You need to write a check in the code to display all records if 'All' is selected.

Thanks,
Amit

Report message to a moderator

Re: please help [message #385781 is a reply to message #385771]

Wed, 11 February 2009 00:47

charuamit
Messages: 121
Registered: January 2009

Senior Member

Thanks.......
Smart suggestion Smile

I was trying all things with dynamically updating LOV,record group,List.....
But didnt try what u suggested.

Thanks A Lot.
Charu.

Report message to a moderator

Previous Topic:	Avoid error message if canvas doesn't exist
Next Topic:	How to populate a different block after insert

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 10:02:40 CST 2025