LOV letter replacement [message #644712] |
Sun, 15 November 2015 06:58 |
kuwait
Messages: 55 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 |
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 #644836 is a reply to message #644796] |
Wed, 18 November 2015 09:45 |
|
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.
Craig...
[Updated on: Wed, 18 November 2015 09:46] Report message to a moderator
|
|
|
|