Home » Developer & Programmer » Forms » LOV letter replacement
icon5.gif  LOV letter replacement [message #644712] Sun, 15 November 2015 06:58 Go to next message
kuwait
Messages: 53
Registered: October 2007
Member
I have a form in Arabic with LOV I want to unify a search, that if a user types a word containing the arabic letter أ or ا it returns the same result,
what exactly I meant considering these two letters as one letter but written in different format it'll return the same result, as if the LOV considers small and cap letters the same. I think of replace function but how to do it tried to search and couldn't reach a solution any clue?

thanks

I'm using Oracle Forms 6i

[Updated on: Sun, 15 November 2015 07:12]

Report message to a moderator

Re: LOV letter replacement [message #644789 is a reply to message #644712] Tue, 17 November 2015 15:32 Go to previous messageGo to next message
dude4084
Messages: 222
Registered: March 2005
Location: Mux
Senior Member
Have idea from here.

For example, if user enter "s" or "S" , it should bring all records starting with s or S.

(Assume msearch is field)


Try this
Select *
from emp
where ((((msearch='s') or (msearch='S')) and (ename like 'S' or ename like 's'))  or 
     (ename like msearch)) 





Just hav the idea from above example and apply it
Re: LOV letter replacement [message #644796 is a reply to message #644789] Wed, 18 November 2015 00:43 Go to previous messageGo to next message
kuwait
Messages: 53
Registered: October 2007
Member
Thanks,

But I don't want to create a search field I want it from LOV search field.

Any clue?
Re: LOV letter replacement [message #644836 is a reply to message #644796] Wed, 18 November 2015 09:45 Go to previous messageGo to next message
CraigB
Messages: 386
Registered: August 2014
Location: Utah, USA
Senior Member
You can't modify the standard Oracle LOV object. So you will have to use a work-around. While not ideal, you could create your own version of the Oracle LOV object (basically and Data block/Canvas/Window group that looks like the Oracle LOV) so it works the way you want it too. I've had to do this in the past. It isn't too difficult. Smile

Craig...

[Updated on: Wed, 18 November 2015 09:46]

Report message to a moderator

Re: LOV letter replacement [message #644839 is a reply to message #644836] Wed, 18 November 2015 10:09 Go to previous message
kuwait
Messages: 53
Registered: October 2007
Member
Thanks, Yes i know how to do it by blocks and fields but I wanted to make use of LOV's no problem thanks anyway.
Previous Topic: Forms Query Issue
Next Topic: Error while compiling the form
Goto Forum:
  


Current Time: Tue Oct 27 02:09:15 CDT 2020