OraFAQ Forum: Forms » To get list values starting with a particular alphabet

Home » Developer & Programmer » Forms » To get list values starting with a particular alphabet

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

To get list values starting with a particular alphabet [message #525235]

Fri, 30 September 2011 04:21

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.

Report message to a moderator

Re: To get list values starting with a particular alphabet [message #525239 is a reply to message #525235]

Fri, 30 September 2011 05:35

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

Senior Member
Account Moderator

DISTINCT applies to the whole column list, not only BPT_VEN_NM.
When referencing a block and an item, you must not enclose them into single quotes (because they are treated as an ordinary string), but precede their name with a colon (:) sign.

Something like this:

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

I don't know whether it will do what you are after, but you may try.

Report message to a moderator

Re: To get list values starting with a particular alphabet [message #525272 is a reply to message #525235]

Fri, 30 September 2011 08:09

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

poojamunj wrote on Fri, 30 September 2011 05:21

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.

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

Report message to a moderator

Previous Topic:	FRM-40202 Field must be entered dialogue not closing
Next Topic:	How to pass table name by reference to Function?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 23:22:07 CST 2025