Home » Developer & Programmer » Forms » Populating LOV with Like operator (oracle 10g Forms)
Populating LOV with Like operator [message #411462] Sat, 04 July 2009 01:48 Go to next message
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 #411463 is a reply to message #411462] Sat, 04 July 2009 01:53 Go to previous messageGo to next message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
Good Question

You can use Default_where option in Set_Block_property


Regards


Shahzaib ismail
Re: Populating LOV with Like operator [message #411467 is a reply to message #411462] Sat, 04 July 2009 02:16 Go to previous message
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....
Previous Topic: Hierarchical Query for Employee
Next Topic: ORA-00600: internal error code, while compiling oracle forms 6i.
Goto Forum:
  


Current Time: Wed Dec 07 14:26:27 CST 2016

Total time taken to generate the page: 0.11497 seconds