| 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 #667681 is a reply to message #667663] |
Wed, 10 January 2018 08:00  |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
|
What about creating an LOV wit no where clause, then when the list pops up, start typing away and the list will shrink to match what you type. It will be slow, especially if your tables has millions of rows.
|
|
|
|
|
|
| Re: Sugestion search in Oracle Forms 6i [message #667704 is a reply to message #667701] |
Thu, 11 January 2018 04:24 |
cookiemonster
Messages: 13963
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
. Any idea for an advance search like gooogle in Forms 6i