OraFAQ Forum: Forms » How to make search if i enter name it automatically search in the list like google

Home » Developer & Programmer » Forms » How to make search if i enter name it automatically search in the list like google (Oracle forms 10g)

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

How to make search if i enter name it automatically search in the list like google [message #673851]

Wed, 12 December 2018 15:02

Farhan ud din
Messages: 32
Registered: October 2018
Location: malakand

Member

Hello Every one , i want to know that how to make search like if we want to search name as we start type matching names automatically comes to the list ,, anyone please plz help me;

Attachment: orafaq.png
(Size: 96.57KB, Downloaded 813 times)

Report message to a moderator

Re: How to make search if i enter name it automatically search in the list like google [message #673852 is a reply to message #673851]

Wed, 12 December 2018 15:14

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Farhan ud din wrote on Wed, 12 December 2018 13:02

Hello Every one , i want to know that how to make search like if we want to search name as we start type matching names automatically comes to the list ,, anyone please please help me;

which SCHEMA.TABLE.COLUMN should be used to offer search suggestions from?
how does this column get populated?

Report message to a moderator

Re: How to make search if i enter name it automatically search in the list like google [message #673871 is a reply to message #673852]

Thu, 13 December 2018 11:38

Farhan ud din
Messages: 32
Registered: October 2018
Location: malakand

Member

Any table let suppose i want ename column from emp table help me please

Report message to a moderator

Re: How to make search if i enter name it automatically search in the list like google [message #673874 is a reply to message #673851]

Thu, 13 December 2018 12:39

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

Senior Member

How about an LOV with all the values from the column. when you start typing the list will shrink to match what you are typing.
I am sorry, that's all I can offer with the short description provided.

Report message to a moderator

Re: How to make search if i enter name it automatically search in the list like google [message #673875 is a reply to message #673874]

Thu, 13 December 2018 13:19

Farhan ud din
Messages: 32
Registered: October 2018
Location: malakand

Member

You are right dear but lovs are another logic i want to do it in search box lovs are time consuming and not looking good ..

Report message to a moderator

Re: How to make search if i enter name it automatically search in the list like google [message #673884 is a reply to message #673875]

Fri, 14 December 2018 03:35

cookiemonster
Messages: 13904
Registered: September 2008
Location: Rainy Manchester

Senior Member

There's no way to do this with normal forms code.
It might be possible with some java plugged in but I've never done that so it's hard to be sure.

Report message to a moderator

Re: How to make search if i enter name it automatically search in the list like google [message #673885 is a reply to message #673884]

Fri, 14 December 2018 03:47

Farhan ud din
Messages: 32
Registered: October 2018
Location: malakand

Member

Yes sir you are right do you know any technical person who can teach me this that how to do this

Report message to a moderator

Previous Topic:	How to copy image from one folder to another using Oracle Form 6i
Next Topic:	hide password in sql

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 24 22:22:33 CDT 2023