| Populating LOV with Like operator [message #411462] |
Sat, 04 July 2009 01:48  |
sprity
Messages: 18
Registered: July 2009
|
Junior Member |
|
|
Hi....
Iam trying a populate a LOV using like operator.
i want a solution for this for the following problem...
I have a text box as 'inp' and i have a list box with values Name,addr,subject.
After entering a substr in text box for example 'BA' and select name in the list box
it should populate a lov having the names where BA appears....
Like this
Radha Bai
Prabakar
Baskar
Whereever BA is present,it should be shown in the LOV.
i have genereated the Lov with the following code
select name from tab_name where name like '%:inp%'
then i have called the lov in when-item-changed.
But LOV is not populating.
i changed the code as select name from tab_name where substr(name,1,1) like substr(:inp,1,1)
it shows the names starting with the first letter of the input.
i want to populate the lov using %:inp%....
Any one help me.....
|
|
|
|
|
|
| Re: Populating LOV with Like operator [message #411467 is a reply to message #411462] |
Sat, 04 July 2009 02:16  |
sprity
Messages: 18
Registered: July 2009
|
Junior Member |
|
|
i got it...
it worked as i coded the following query.
select NAME from tab_name where upper(name) like '%' || upper(:inp) || '%'
thanx for your reply....
and special thanks to a frnd who gave solution for this....
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
