Home » Developer & Programmer » Forms » Sugestion search in Oracle Forms 6i (Oracle Forms 6i)
 Sugestion search in Oracle Forms 6i [message #667663] |
Wed, 10 January 2018 01:33  |
 |
NDKA739125
Messages: 33
Registered: January 2018
|
Member |
|
|
Good day
I'm doing a search forms, using oracle forms 6i. I would like to create a sugesstion search, for example. When I type 'A' in the Text Item, the query will be executed, "select name from emp where name like 'A%';" and the result will be shown (I already created the layout). And when I continue to put more , like 'AS', the query will be executed again, and it now changes to "select name from emp where name like 'AS%';". All I would like to do is, everytime I type from my keyboard, the query will be execute automatically, so wich trigger allow me to do that ?
Thanks in advance.
NDKA.
[Updated on: Wed, 10 January 2018 01:53] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: Sugestion search in Oracle Forms 6i [message #667704 is a reply to message #667701] |
Thu, 11 January 2018 04:24  |
cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
No. For one forms just isn't designed to work that way.
But even if you're using a front end that can what google does is really hard.
They aren't just executing a general query everytime you type something.
They're querying subsets of data - toplists of the most commonly typed search phrases that start with what ever.
They will not be querying the underlying main set of data every time.
|
|
|
|
Goto Forum:
Current Time: Thu Apr 17 07:04:42 CDT 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
. Any idea for an advance search like gooogle in Forms 6i