Home » Developer & Programmer » Forms » How to manage the result of LOV?
How to manage the result of LOV? [message #282189] Wed, 21 November 2007 02:10 Go to next message
nadia74
Messages: 85
Registered: August 2007
Member
Hi,
I'm working on database oracle 10g and form developer 6i.
I have LOV returns the first name and the last name of the employees.If I press f9 and write the first letter (S for example)it brings the employees whoes first name begin with S, what i want is that after writting the first letter i want to put space and write another letter (W) in this case it should brings the employees whose first name begin with S and last name begin with S.
Regards
Re: How to manage the result of LOV? [message #282212 is a reply to message #282189] Wed, 21 November 2007 03:27 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Use wildcard characters.
Re: How to manage the result of LOV? [message #282239 is a reply to message #282189] Wed, 21 November 2007 04:10 Go to previous messageGo to next message
nadia74
Messages: 85
Registered: August 2007
Member
Thanks for your reply, but could you be more specific.
Regards
Re: How to manage the result of LOV? [message #282247 is a reply to message #282239] Wed, 21 November 2007 04:27 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Something like this example: the default search condition is '%' (give me everything). Entering '15%30', I'd get corresponding values (as on the second image).

Single character wildcard is underscore (_), while multiple characters wildcard is percent sign (%).

./fa/3421/0/

Re: How to manage the result of LOV? [message #282257 is a reply to message #282247] Wed, 21 November 2007 05:07 Go to previous messageGo to next message
nadia74
Messages: 85
Registered: August 2007
Member
Thanks.
If you try it on characters it will bring every last name which (for example)has letter S.
regards
Re: How to manage the result of LOV? [message #282413 is a reply to message #282257] Wed, 21 November 2007 23:13 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Then put a 'space' before the '%' so that it aligns to the space separating the first and last names.

David
Re: How to manage the result of LOV? [message #282471 is a reply to message #282413] Thu, 22 November 2007 01:45 Go to previous messageGo to next message
nadia74
Messages: 85
Registered: August 2007
Member
It didn't work I still have the same problem.
Regards
Re: How to manage the result of LOV? [message #282638 is a reply to message #282471] Thu, 22 November 2007 19:21 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Pardon. Please post snapshot of a search like "Dav% Mar%" from a list containing a list of First and Last names separated by a 'space' to show that it doesn't work.

Are you sure you have the 'case' of your search correct?

David
Previous Topic: Unable to read mapped drive
Next Topic: Very Basic User Form
Goto Forum:
  


Current Time: Thu Dec 08 03:46:16 CST 2016

Total time taken to generate the page: 0.07194 seconds