Try this:

in OrderingItems put only desc statement like:

nr=nr desc

so there is one order direction only, BUT in IB_grid the glyph is indicating
an ascanding order. Now replace standard glyphs with your own (maybe better
one) indicating right order direction.

Second alternative is to us TIB_Query.OnOrderingChanged event. In
OrderingItems put both order directions, e.g.

nr=nr;nr desc

If user clicks on column title check TIB_Query.OrderingItemNo and set it to
negative value. So you can use standard glyphs.

Mit freundlichem Gruss & Best Regards

Andreas Pohl
apohl@...
www.ibp-consult.com

----- Original Message -----
From: "Michael L. Horne" <guardian@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, February 23, 2001 1:26 PM
Subject: RE: [IBO] Incremental searching on descending OrderingItems does
not work


> Hello
>
> There is some files in my DB that the users need to look at in
> descending order, (most recent records first). They almost never
> want to look at the data in ascending order.
>
> Changing the value to negative doesn't solve the problem when
> there are multiple columns to sort on.
>
> Consider:
> 1. Grid opens with negative OrderingItemNo
> 2. User clicks on Column 2, Grid now in Positive order
> 3. User clicks on Column 2 again, to change to descending
> 4. User clicks on Column 1, Grid now in Positive order
> 5. User clicks on Column 1 again, to change to descending
>
> As you can see, after the initial display having the negative
> OrderingItemNo doesn't solve the problem of needing to
> display the data in descending order normally.
>
> Michael L. Horne
>