Create one more column to each field you want to do case insensitive in your
database.
In triggers, write code to update this new column with the uppercase from
equivalent column.
Create indexes on this new columns to speed up the search.
Indexes on original columns aren't necessary.
In "UPPER-CASE EQUIVALENT" put the name of this new column that you create
to save uppercase text.

Luiz.

----- Original Message -----
From: Salvatore Besso <s.besso@...>
To: IB Objects <IBObjects@yahoogroups.com>
Sent: Friday, July 20, 2001 9:34 AM
Subject: [IBO] Question about TIB_Query


> hello all,
>
> I am new to both Interbase and IB Objects and I have a small problem
> regarding some properties of TIB_Query.
>
> I want to make two fields of a table case-insensitive for search but
> not for display. I have seen a page in the properties where I can mark
> a "CASE INSENSITIVE" check box and where I have to supply something in
> the "UPPER-CASE EQUIVALENT" edit line. The problem is: What have I to
> supply in this edit line ?
>
> I have tried with UPPER(NAME) where "NAME" is the name of the field
> that has to be case insensitive. It seems to work with the search
> panel that I have associated to the form, but when I cancel the search
> mode I receive an Sql error:
>
> Token unknown:
>
> UPPER
>
> Can someone clarify the mechanism of case insensitivity ?
>
> Thanks a lot
> Salvatore Besso
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>