Home » Developer & Programmer » Forms » How to make search if i enter name it automatically search in the list like google (Oracle forms 10g)
How to make search if i enter name it automatically search in the list like google [message #673851] Wed, 12 December 2018 15:02 Go to next message
Farhan ud din
Messages: 22
Registered: October 2018
Location: malakand
Junior 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 357 times)
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 Go to previous messageGo to next message
BlackSwan
Messages: 26648
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?
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 Go to previous messageGo to next message
Farhan ud din
Messages: 22
Registered: October 2018
Location: malakand
Junior Member

Any table let suppose i want ename column from emp table help me please
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 Go to previous messageGo to next message
joy_division
Messages: 4949
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.
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 Go to previous messageGo to next message
Farhan ud din
Messages: 22
Registered: October 2018
Location: malakand
Junior 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 ..
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 Go to previous messageGo to next message
cookiemonster
Messages: 13777
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.
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 Go to previous message
Farhan ud din
Messages: 22
Registered: October 2018
Location: malakand
Junior Member

Yes sir you are right do you know any technical person who can teach me this that how to do this
Previous Topic: How to copy image from one folder to another using Oracle Form 6i
Next Topic: hide password in sql
Goto Forum:
  


Current Time: Sat Jan 18 14:37:47 CST 2020