| form6i lov [message #356493] |
Thu, 30 October 2008 22:23  |
xynhaha
Messages: 4
Registered: October 2008
|
Junior Member |
|
|
when show lov,how can auto goto filter item
help
thanks
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: form6i lov [message #356531 is a reply to message #356509] |
Fri, 31 October 2008 00:33  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
"auto goto" ... I like that!
If you want a specific order, then use ORDER BY clause in the record group's query (you may even use a DESCENDING order, if it helps).
[EDIT] Sorry, submitting too fast ...
If you *know* which LoV value is / might be the best choice for the user, you may populate the item BEFORE actually opening the list of values. If the user is satisfied with this value, he/she will accept it and go on. If not, he/she may open the list of values and select something else.
[Updated on: Fri, 31 October 2008 00:35] Report message to a moderator |
|
|
|
| Re: form6i lov [message #356847 is a reply to message #356531] |
Sun, 02 November 2008 19:27 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
You can also have another hidden column (its width is zero), then in the 'select' statement have a 'union' between the 'default' value sorted as a '1' and the 'other' items sorted as a '2'. For example:
select 'ZZZ', 1
from dual
union
select dummy, 2
from dual
order by 2;'ZZ 1
--- ----------
ZZZ 1
X 2
This will place the 'default' value ('ZZZ') at the top of the list.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
