OraFAQ Forum: Forms » how to set lov search value

Home » Developer & Programmer » Forms » how to set lov search value

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

how to set lov search value [message #540396]

Mon, 23 January 2012 05:01

umann85
Messages: 16
Registered: January 2012
Location: India

Junior Member

Hello,

I am using oracle 10g 10.1.0.2.0
I want to set lov search value means when we open lov then in search text box it show % but i want to set 1%.

Please help me as soon as possible....

Thanks in advance

I am sorry for not proper using oracle forum ......

Report message to a moderator

Re: how to set lov search value [message #540402 is a reply to message #540396]

Mon, 23 January 2012 05:23

cookiemonster
Messages: 13972
Registered: September 2008
Location: Rainy Manchester

Senior Member

If you have validate from list set to Yes forms will automatically put whatever is typed in the field in the LOV.
There is no other way of affecting the LOV search string when it opens.

Report message to a moderator

Re: how to set lov search value [message #540403 is a reply to message #540402]

Mon, 23 January 2012 05:34

umann85
Messages: 16
Registered: January 2012
Location: India

Junior Member

Sorry I am not getting "List set to yes" Please Tell me What I can do for this.

Thanks for my asked question to reply...

Report message to a moderator

Re: how to set lov search value [message #540404 is a reply to message #540403]

Mon, 23 January 2012 05:39

cookiemonster
Messages: 13972
Registered: September 2008
Location: Rainy Manchester

Senior Member

"Validate from list" is an item property found in the property pallete.

Report message to a moderator

Re: how to set lov search value [message #540406 is a reply to message #540404]

Mon, 23 January 2012 05:57

Tomcrzy
Messages: 101
Registered: December 2011
Location: Chennai,India

Senior Member

Is it possible? I dont think so !

Quote:

I want to set lov search value means when we open lov then in search text box it show % but i want to set 1%.

I think these are belong to the default properties of forms

Report message to a moderator

Re: how to set lov search value [message #540410 is a reply to message #540406]

Mon, 23 January 2012 06:10

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

umann85

I want to set lov search value means when we open lov then in search text box it show % but i want to set 1%.

If your LoV is based on Record Group's query which - for example - looks like this:

select ename
from emp

and you ALWAYS want LoV to display values that begin with a certain character, you could simply modify a query:

select ename
from emp
where ename like 'A%'

Or, you could even create a non-database item (let's call it START_CHAR) and use it in Record Group's query:

select ename
from emp
where ename like :start_char ||'%'

Various possibilities, I'd say.

Report message to a moderator

Previous Topic:	changing the button color at runtime
Next Topic:	How to reset error codes

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 13 23:52:06 CDT 2025