Riho-Rene,

you need to add an uppercase equivalent of the column you wish to
incrementally search on. If the table is small then it can be just a
computed column. If the table is large then I use triggers to maintain a
real () upper case equivalent) column and create an index for it.

Then, in your ColumnAttributes designate the mixed case column as Case
Insensitive and name the uppercase equivalent column.

Then incremental searching will work like a charm :-)

HTH,

Brian

> -----Original Message-----
> From: Riho-Rene Ellermaa [mailto:r.ellermaa@...]
> Sent: Wednesday, 4 April 2001 6:19 PM
> To: IBObject (E-mail)
> Subject: [IBO] Incremental search trouble
>
>
> My query:
> select * from Corresp
> for update
>
> Ordering:Name=Name,account;Name desc,account
> Name is marked as case insensitive
>
> Data is:
> abcde
> bcdef
> geftg
> GEFG
> KLMN
>
> When I enter into Incr. search field 'b', then bcdef is found
> -OK. When I
> enter 'K' , nothing is found.
> When I change the sort order:
> KLMN
> GEFG
> geftg
> bcdef
> abcde
>
> then I can search by 'K', but not by 'b'. Seems that tere are
> troubles with
> big and small letters
> I'm using 3.6A version of IBO
>
> Riho-Rene Ellermaa
> senior programmer
> Hansabank
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-~>
> Find software faster. Search more than 20,000
> software solutions on KnowledgeStorm. Register
> now and get started.
> http://us.click.yahoo.com/kVJDAA/zMSCAA/Ig4EAA/P0AVlB/TM
> --------------------------------------------------------------
> -------_->
>
>
>
> Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/