Home » Developer & Programmer » Forms » form6i lov (form6i xp)
form6i lov [message #356493] Thu, 30 October 2008 22:23 Go to next message
xynhaha
Messages: 4
Registered: October 2008
Junior Member
when show lov,how can auto goto filter item

help
thanks
Re: form6i lov [message #356496 is a reply to message #356493] Thu, 30 October 2008 22:29 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Set it to 'Yes'.

David
Re: form6i lov [message #356500 is a reply to message #356496] Thu, 30 October 2008 22:37 Go to previous messageGo to next message
xynhaha
Messages: 4
Registered: October 2008
Junior Member
i don't know
Re: form6i lov [message #356502 is a reply to message #356500] Thu, 30 October 2008 22:47 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Try it and see what happens.

David
Re: form6i lov [message #356506 is a reply to message #356502] Thu, 30 October 2008 23:05 Go to previous messageGo to next message
xynhaha
Messages: 4
Registered: October 2008
Junior Member
?
SET_LOV_PROPERTY (lov-id,????,PROPERTY_TRUE)

help
tell me
thanks
Re: form6i lov [message #356507 is a reply to message #356506] Thu, 30 October 2008 23:10 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
In the Froms Builder, for your LOV, set the various 'Automatic' properties to 'yes'.

David
Re: form6i lov [message #356509 is a reply to message #356507] Thu, 30 October 2008 23:26 Go to previous messageGo to next message
xynhaha
Messages: 4
Registered: October 2008
Junior Member
when open lov ,cursor how auto goto top filter(FIND) item

?

[Updated on: Fri, 31 October 2008 00:06]

Report message to a moderator

Re: form6i lov [message #356531 is a reply to message #356509] Fri, 31 October 2008 00:33 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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;
gives
'ZZ          1
--- ----------
ZZZ          1
X            2

This will place the 'default' value ('ZZZ') at the top of the list.

David
Previous Topic: Setting Visual attribute to a specific record in tabular block if the condition is satisfied
Next Topic: problem in client bworser using vista
Goto Forum:
  


Current Time: Fri Dec 09 19:17:00 CST 2016

Total time taken to generate the page: 0.08586 seconds