LOV issue [message #169105] |
Tue, 25 April 2006 02:07  |
nirmalnarayan
Messages: 261 Registered: April 2005 Location: India
|
Senior Member |
|
|
I have a LOV associated with a text field, but the problem here is the LOV is being displayed only when the user presses tab from the field.
I need to display the LOV as the user types in some values in the field, (i.e., still the user has not stepped out of the field by pressing the tab) also need to display the LOV values filtered as the user types in some value to the field.
Anyone have idea how this can be achieved.
Thanks
Nirmal
|
|
|
|
|
Re: LOV issue [message #169130 is a reply to message #169126] |
Tue, 25 April 2006 04:25   |
 |
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Right!
That's exactly what Forms does:Forms Online Help | When Validate from List is Yes, Oracle Forms compares the current value of the text item to the values in the first column displayed in the LOV whenever the validation event occurs:
- If the value in the text item matches one of the values in the first column of the LOV, validation succeeds, the LOV is not displayed, and processing continues normally.
- If the value in the text item does not match one of the values in the first column of the LOV, Oracle Forms displays the LOV and uses the text item value as the search criteria to automatically reduce the list.(etc.)
| What I meant to say was this: if the user enters, for example, 'SALES' into the "dname" field and presses nothing else (TAB, Enter, Ctrl+L ... nothing after the last "S"), Forms will do nothing because it doesn't yet know that validation should occur.
If I understood it well, Nirmalnarayan wanted validation BEFORE pressing the TAB key. I still think that this isn't possible.
OK, I guess things are quite clear here. I'm sorry if I was misunderstood; explaining things in foreign language isn't always as easy as I'd like it to be
|
|
|
Re: LOV issue [message #169155 is a reply to message #169130] |
Tue, 25 April 2006 06:43   |
nirmalnarayan
Messages: 261 Registered: April 2005 Location: India
|
Senior Member |
|
|
Thanks Littlefoot,
You guessed it right, i need validation BEFORE pressing the TAB key, but i think it is something impossible in FORMS, can you suggest any workaround to achieve the same.
i.e., while you type something in the field, the LOV should be displayed, filtered with the entered value.
I.e, if the user types 1 the LOV will display values starting with 1.
Nirmal.
|
|
|
|
|
|
Re: LOV issue [message #169831 is a reply to message #169173] |
Sat, 29 April 2006 02:05   |
 |
Maaher
Messages: 7065 Registered: December 2001
|
Senior Member |
|
|
Nirmal, did the list-item approach deliver what you wanted? Just a small reminder that this is not advisable though, because at each and every manipulation of the list a query is launched against the database.
MHE
[Updated on: Sat, 29 April 2006 02:06] Report message to a moderator
|
|
|
|
Re: LOV issue [message #281791 is a reply to message #281788] |
Mon, 19 November 2007 05:41   |
 |
Maaher
Messages: 7065 Registered: December 2001
|
Senior Member |
|
|
True, that's why I never implemented this on production. I'd probably use a standard LOV.
azamkhan wrote on Mon, 19 November 2007 12:37 | Dear Maaher a good programmer must has more then one alternate.
| I always thought it was like this: "A good programmer is an excellent thief". 
MHE
[Updated on: Mon, 19 November 2007 05:44] Report message to a moderator
|
|
|
|