You need an uppercase equivalent column.

I think IBO should actually put in the UPPER ( ) in the ORDER BY clause and
allow InterBase to raise an exception until they get it supported.

For now I just leave it out and I suppose I shouldn't.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Riho-Rene Ellermaa" <r.ellermaa@...>
To: "IBObject (E-mail)" <IBObjects@yahoogroups.com>
Sent: Wednesday, April 04, 2001 3:18 AM
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
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>