Home » Developer & Programmer » Forms » how to set lov search value
how to set lov search value [message #540396] Mon, 23 January 2012 05:01 Go to next message
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 ......
Re: how to set lov search value [message #540402 is a reply to message #540396] Mon, 23 January 2012 05:23 Go to previous messageGo to next message
cookiemonster
Messages: 10914
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.
Re: how to set lov search value [message #540403 is a reply to message #540402] Mon, 23 January 2012 05:34 Go to previous messageGo to next message
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...
Re: how to set lov search value [message #540404 is a reply to message #540403] Mon, 23 January 2012 05:39 Go to previous messageGo to next message
cookiemonster
Messages: 10914
Registered: September 2008
Location: Rainy Manchester
Senior Member
"Validate from list" is an item property found in the property pallete.
Re: how to set lov search value [message #540406 is a reply to message #540404] Mon, 23 January 2012 05:57 Go to previous messageGo to next message
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
Re: how to set lov search value [message #540410 is a reply to message #540406] Mon, 23 January 2012 06:10 Go to previous message
Littlefoot
Messages: 19510
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.
Previous Topic: changing the button color at runtime
Next Topic: How to reset error codes
Goto Forum:
  


Current Time: Thu Aug 28 00:59:46 CDT 2014

Total time taken to generate the page: 0.94782 seconds