create a single column that orders the data as you want maintain this by
trigger and order on that one column.

Leigh

-----Original Message-----
From: Michael L. Horne [mailto:guardian@...]
Sent: Friday, February 23, 2001 7:26 AM
To: IBObjects@yahoogroups.com
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

> -----Original Message-----
> From:
> sentto-402930-4179-982910552-guardian=pobox.com@...
> [mailto:sentto-402930-4179-982910552-guardian=pobox.com@....
> com]On Behalf Of Jörg Schiemann
> Sent: Friday, February 23, 2001 1:43 AM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Incremental searching on descending OrderingItems
> does not work
>
>
> Hi Michael,
>
> why do you think that the negative value doesn't fix the problem?
>
> After I changed the OrderingItemNo to -1 the grid uses a descending
> order, and the incremental searching still works.
>
> Regards,
> Jörg Schiemann
>
> ----- Original Message -----
> From: "Michael L. Horne" <guardian@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Thursday, February 22, 2001 11:49 PM
> Subject: RE: [IBO] Incremental searching on descending OrderingItems does
> not work
>
>
> > Hello
> >
> > Jason, this seems to be a problem to me, even though we can use
> > the NEG value to start with this doesn't fix the problem. There
> > are many times when my users want to see the data in descending
> > order, and are rarely interested in seeing the data in ascending
> > order.
> >
> > I haven't ran into this problem yet, but I am about to start on
> > that section of the conversion where I would need to order the
> > data in descending order, and perform incremental searching.
> >
> > Is there any way around this problem?
> >
> > Here is a Work Around/Solution,
> > 1. Define a tEdit, with a OnChange Event.
> > 2. Within the OnChange Event
> > query.Locate(query.SearchingLink, edLocate.Text,
> [lopPartialKey]);
> > 3. You may want to create a OnOrderingChange Event for the
> > query with:
> > edLocate.Text := '';
> > This seems to work with the query in both ascending & descending
> > orders. Not as easy to use as the TIB_IncSearch but it gets the
> > job done.
> >
> > Below is the full code for my OnChange Event:
> >
> > if (edLocate.Text <> '') then
> > begin
> > if Assigned( qyNetComIn.OrderingField ) and
> > qyNetComIn.OrderingField.IsText then
> > begin
> > qyNetComIn.Locate(qyNetComIn.SearchingLink, edLocate.Text,
> > [lopPartialKey]);
> > end;
> > end else begin
> > qyNetComIn.First
> > end;
> >
> > Good Luck
> > Michael L. Horne
> >
> >
> > > -----Original Message-----
> > > From: Jason Wharton [mailto:jwharton@...]
> > > Sent: Thursday, February 22, 2001 3:37 PM
> > > To: IBObjects@yahoogroups.com
> > > Subject: Re: [IBO] Incremental searching on descending OrderingItems
> > > does not work
> > >
> > >
> > > There is a simple way.
> > >
> > > Put an entry for both Ascending and Descending and then set the
> > > OrderingItemNo to the negative so that it will start up in the
> descending
> > > order.
> >
> > > It is intended to work this way. The first entry in that item must
> > actually be ascending and the second must be descending.
> >
> > >
> > > Jason Wharton
> > > CPS - Mesa AZ
> > > http://www.ibobjects.com
> > >
> > >
> > > ----- Original Message -----
> > > From: "Jörg Schiemann" <schimmi@...>
> > > To: <IBObjects@yahoogroups.com>
> > > Sent: Thursday, February 22, 2001 12:23 PM
> > > Subject: Re: [IBO] Incremental searching on descending OrderingItems
> does
> > > not work
> > >
> > >
> > > > I want that the grid start with descending ordering.
> > > >
> > > > Is it possible to start the grid with ascending ordering and
> > > > then simulate the mouseclick on the columnlabel?
> > > >
> > > > Or is there another way?
> > > >
> > > > Regards,
> > > > Jörg Schiemann
>
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/