To get list values starting with a particular alphabet [message #525235] |
Fri, 30 September 2011 04:21 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/eeed21864f80e5fa549e3c52be037eea?s=64&d=mm&r=g) |
poojamunj
Messages: 64 Registered: May 2011 Location: MUMBAI
|
Member |
|
|
Hello Sir,
I have made one LOV for vendor_names. On form level i want that when the user will enter a particular alphabet in a textbox assigned with LOV, the list should popup with only those elements starting with that particular alphabet. I have written the following code in the query of LOV wizard
query:
select distinct(bpt_ven_nm),bpt_ven_cd from bill_hdr1_tab
where bpt_ven_nm like ('enter.vendr_nm'||'%')
order by bpt_ven_nm
Wherin 'Enter' is the name of block and 'vendr_nm' is field name.
But its getting unsuccesfull. Please correct me if i am making any mistake in this query or is there any alternate way to get this result.
|
|
|
|
Re: To get list values starting with a particular alphabet [message #525272 is a reply to message #525235] |
Fri, 30 September 2011 08:09 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
poojamunj wrote on Fri, 30 September 2011 05:21Hello Sir,
I have made one LOV for vendor_names. On form level i want that when the user will enter a particular alphabet in a textbox assigned with LOV, the list should popup with only those elements starting with that particular alphabet. I have written the following code in the query of LOV wizard
query:
select distinct(bpt_ven_nm),bpt_ven_cd from bill_hdr1_tab
where bpt_ven_nm like ('enter.vendr_nm'||'%')
order by bpt_ven_nm
Wherin 'Enter' is the name of block and 'vendr_nm' is field name.
But its getting unsuccesfull. Please correct me if i am making any mistake in this query or is there any alternate way to get this result.
I am easily confused. I do not know what you mean by "alphabet," so I am going to assume you want to show an LOV of entries starting with a single letter identified in another field.
I would use this in the where clause:
where substr(bpt_ven_nm,1,1)=:enter.vendr_nm
|
|
|