Nov 23, 2004 #1 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?
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?
Nov 23, 2004 1 #2 skrandel MIS Aug 23, 2002 1,378 US 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 Upvote 0 Downvote
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