Re: Sorting in drop down list

jcccs05 wrote:
> I had two questions:
>
> I am working in Oracle Forms 10g and I am successful in populating the
> item list with values queries from a database.
>
> i.e. select column1, column2 from tablename order by 1
>
> My question is the following: Is it possible to commingle the sorted
> values. In other words, I have upper and lower case values in tablename
> and when they're ordered, the upper cases appear first and then the
> lower case. Is there anyway to not have oracle do that and instead sort
> them alphabetically regardless of case?

Depends on the version of Oracle and your NLS settings.

But why have options in upper and lower case? This would appear to conflict with good design. One up with a single standard for values in loop-ups and set everything that way using UPPER, LOWER, or INITCAP.
> Secondly, is there a way in Oracle Forms 10g to implement in a
> list-item an auto detect/complete feature? Right now, the drop down
> lists behave in such a way that it does not highlight the most closely
> matched value. It only highlights when you type in a word or select a
> word that is already in the list. I want it to be able to auto
> detect/complete and highlight possible matches for queries you have
> made...I hope that makes sense.
>
> Any help with the first issue would be appreciated. Thanks.

It should do this by default ... what have you changed?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org