Home » Developer & Programmer » Forms » show lov when i enter any letter or number...
show lov when i enter any letter or number... [message #605856] Wed, 15 January 2014 06:25 Go to next message
mist598
Messages: 698
Registered: February 2013
Location: Hyderabad
Senior Member
Hi all,

Suppose if i enter as 'a' & press enter i want to show LOV records starting with a's , as shown below, so, please help me on this.. ,i want to show LOV list like below image , Suggest me what are the properties to set?
./fa/11627/0/

Thank You
  • Attachment: image1.png
    (Size: 7.75KB, Downloaded 105 times)

[Updated on: Wed, 15 January 2014 06:28]

Report message to a moderator

Re: show lov when i enter any letter or number... [message #605857 is a reply to message #605856] Wed, 15 January 2014 06:30 Go to previous messageGo to next message
cookiemonster
Messages: 10573
Registered: September 2008
Location: Rainy Manchester
Senior Member
set validate from list to true
Re: show lov when i enter any letter or number... [message #605858 is a reply to message #605856] Wed, 15 January 2014 06:31 Go to previous messageGo to next message
Littlefoot
Messages: 18833
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
List of Values' "Filter before display" property set to "Yes" might be what you are looking for.

Or, add a condition to LoV Record Group's query so that it could filter retrieved records, such as
... where tprt_number like :block.rading_partner_number ||'%'
Re: show lov when i enter any letter or number... [message #605860 is a reply to message #605858] Wed, 15 January 2014 06:57 Go to previous messageGo to next message
mist598
Messages: 698
Registered: February 2013
Location: Hyderabad
Senior Member
Quote:
set validate from list to true
.
Yes it is working.

Quote:
List of Values' "Filter before display" property set to "Yes" might be what you are looking for.


Quote:
where tprt_number like :block.rading_partner_number ||'%'

I set List of Values' "Filter before display" property set to "Yes", but it Pushes to the FIND Button and navigates to another Canvas and displayed nothing records.
./fa/11628/0/


Thank You...Smile
  • Attachment: image1.png
    (Size: 6.23KB, Downloaded 81 times)
Re: show lov when i enter any letter or number... [message #605862 is a reply to message #605856] Wed, 15 January 2014 07:11 Go to previous messageGo to next message
mist598
Messages: 698
Registered: February 2013
Location: Hyderabad
Senior Member
Hi ,

I want to show LOV beneath the LOV Column, Please go through the image as shown below, Is this possible for me?
./fa/11629/0/


Thank You
  • Attachment: image1.png
    (Size: 9.28KB, Downloaded 72 times)
Re: show lov when i enter any letter or number... [message #605864 is a reply to message #605862] Wed, 15 January 2014 07:28 Go to previous messageGo to next message
Littlefoot
Messages: 18833
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Of course it is possible; did you not see X and Y position LoV properties?
icon14.gif  Re: show lov when i enter any letter or number... [message #605865 is a reply to message #605864] Wed, 15 January 2014 07:44 Go to previous message
mist598
Messages: 698
Registered: February 2013
Location: Hyderabad
Senior Member
Quote:
did you not see X and Y position LoV properties?


Thank You help Littlefoot, you have more patience to reply Smile
Previous Topic: How to create demo version of application using Oracle Form 6i
Next Topic: multiple master-detail relationship
Goto Forum:
  


Current Time: Sat Apr 19 15:18:33 CDT 2014

Total time taken to generate the page: 0.26767 seconds