Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

LOV Order 1

Status
Not open for further replies.

tunjio

MIS
Aug 11, 2004
24
GB
Can anyone tell me if there is a way that I can force a LOV to be displayed in numerical order, either ascending or descending?
 
Sure.

In V5, you would have to edit the LOV and force a sort.

In V6, there is a universe paramter "FORCE_SORTED_LOV". For some reason it's set to NO by default.

You're probably using SQL Server. It's the only database I've ever used that doesn't sort values after a Select Distinct.

Steve Krandel
VERITAS Software
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top