Subject Re: [IBO] Case-insensitive sorting
Author Antti Kurenniemi
----- Original Message -----
From: "mspencewasunavailable" <firebird@...>
To: <>
Sent: Tuesday, September 12, 2006 2:13 AM
Subject: Re: [IBO] Case-insensitive sorting

> Adding ORDER BY UPPER(<fieldname>) to the TIB_QUERY works
> fine for me when used with a grid. Is there some reason you can't do
> this? (Don't know whether this'd work with a search, but I'd bet there's
> a way.)

I'm using the built-in sorting of IBO, with OrderingItems and OrderingLinks,
and I couldn't find a way to add the "UPPER" in there anywhere. Are you
setting the query manually when the sorting changes?

Antti Kurenniemi