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 Go to next message
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 #667669 is a reply to message #667663] Wed, 10 January 2018 03:10 Go to previous messageGo to next message
cookiemonster
Messages: 13787
Registered: September 2008
Location: Rainy Manchester
Senior Member
There isn't one.
It might be possible with java beans, I wouldn't know.
It'll almost certainly be slow so I really wouldn't bother.
Re: Sugestion search in Oracle Forms 6i [message #667681 is a reply to message #667663] Wed, 10 January 2018 08:00 Go to previous messageGo to next message
joy_division
Messages: 4949
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 #667701 is a reply to message #667681] Thu, 11 January 2018 01:41 Go to previous messageGo to next message
NDKA739125
Messages: 33
Registered: January 2018
Member
Tks for your advices,
I tested the performance and It was so damn slow, for real Sad. Any idea for an advance search like gooogle in Forms 6i Sad ?
Re: Sugestion search in Oracle Forms 6i [message #667704 is a reply to message #667701] Thu, 11 January 2018 04:24 Go to previous message
cookiemonster
Messages: 13787
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.
Previous Topic: oracle forms 6I print on printer hasar
Next Topic: Unable to read image on weblogic server 12c
Goto Forum:
  


Current Time: Fri Jan 24 17:33:03 CST 2020