Thanks Set. I'll have to do some reading on the case insensitive character
sets.


Antti Kurenniemi

----- Original Message -----
From: "Svein Erling Tysvaer" <svein.erling.tysvaer@...>
To: <ibobjects@yahoogroups.com>
Sent: Tuesday, September 12, 2006 12:09 AM
Subject: Re: [IBO] Case-insensitive sorting


> Hi Antti!
>
> I think there are two different ways to get case insensitive sorting,
> one is to use a case insensitive character set (or maybe it is
> collation?), the other is to add another column that should contain the
> uppercase equivalent of your column, populate this column through
> insert/update triggers and then specify this field as the uppercase
> equivalent of your mixed case field and then IBO does the rest
> (unfortunately, I don't remember the name of the property, but it is one
> simple property relating to the field in your TIB_Query).
>
> HTH,
> Set
>
> Antti Kurenniemi wrote:
>> Hi all,
>>
>> I'm (once again) probably missing something quite obvious, but how can I
>> make IBO grids sort case-insensitive? It seems that the default sort
>> differentiates upper- and lowercase characters which, while technicaly
>> accurate, is not what I want. It also makes the searches (including
>> Locate)
>> work wrong. For example, a column with the following values:
>>
>> Kalavale
>> KOS - Kouhian Outo Seurue
>> Kopiotoimi Tampereella
>>
>> will never find the "Kopiotoimi" value because it stops on "KOS", and
>> this
>> is a bit bonkers (for the users). Any help appreciated.
>>
>>
>> TIA,
>> Antti Kurenniemi
>
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
> papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>