OraFAQ Forum: Forms » Dynamic search in Text using LOV

Home » Developer & Programmer » Forms » Dynamic search in Text using LOV (Oracle forms 10g, windows 7)

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

Dynamic search in Text using LOV [message #609632]

Mon, 10 March 2014 09:19

thelearner
Messages: 133
Registered: April 2013
Location: INDIA

Senior Member

Hi,
I want to display empno based on search criteria(If I enter 7 and press tab then it should display empnos starting with 7 using LOV),
If only one empno is there then it should automatically replace into text item.
How to do this?

Please help me.

Thanks.
The Learner.

Report message to a moderator

Re: Dynamic search in Text using LOV [message #609656 is a reply to message #609632]

Tue, 11 March 2014 00:41

mehboob110233
Messages: 55
Registered: February 2014
Location: Pakistan

Member

you will count record before call lov if the count greater then 1 then show lov
else
call the value direct from the table where you call the lov query......

-------------------------
filtration.....

for selection as like you said 7 you give
for this in lov query you add like operator at the end of the lov query
like '%:empno%'

i hope this will help you..

Report message to a moderator

Re: Dynamic search in Text using LOV [message #609659 is a reply to message #609656]

Tue, 11 March 2014 01:12

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

Senior Member
Account Moderator

I think that all you have to do is to
- set item's "Validate from list" property to YES
- set LoV's "Automatic Select" property to YES

Report message to a moderator

Previous Topic:	Issue while query record in form based on master detail relationship.
Next Topic:	Oracle 10g Font Problem in Runtime

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 22:12:35 CST 2025