OraFAQ Forum: Forms » get ride of "%" while searching

Home » Developer & Programmer » Forms » get ride of "%" while searching (oracle form 11g)

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

get ride of "%" while searching [message #553287]

Thu, 03 May 2012 03:54

mahnazzz
Messages: 98
Registered: July 2011
Location: Iran

Member

hi
would you please help me how I can get ride of "%" while searching.
it is not Uncomfortable for my user to search by "%".
thanks

Report message to a moderator

Re: get ride of "%" while searching [message #553289 is a reply to message #553287]

Thu, 03 May 2012 04:00

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Tell them not to search by "%".

(One of) Oracle wildcard(s) is %. So, if they don't need a wildcard, they won't use it. If they need it, they will use it. Can't be simpler.

Everything else but following default (Oracle) Forms functionalities means that you need to code it. For example, in a PRE-QUERY trigger, you might use something like

:ename like '%' || :ename || '%';

in order to add % instead of your users. Now imagine a form with 10, 20 or more items, all of them searchable. Now multiply that number with number of forms. If you are that kind to save users from typing a single % when needed, go for it!

Report message to a moderator

Re: get ride of "%" while searching [message #553511 is a reply to message #553289]

Sat, 05 May 2012 22:06

mahnazzz
Messages: 98
Registered: July 2011
Location: Iran

Member

You are absolutely right

Report message to a moderator

Previous Topic:	How to generate excel in oracle forms 11g?????
Next Topic:	call report using RUN_PRODUCT on Forms 6i and 11g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 04:18:22 CST 2025