Subject Re: [IBO] Another ordering queston
Author Paul Vinkenoog
Hi Zile,

> I would like to set that first click on column header in grid
> control makes query order by that column in DESC order ? Default
> behaviour of the grid is to order items in ASC Order. How to change
> it ?

I never tried this, but it seems to me that you ought to:

1. Open the OrderingItems of the Query the grid is linked to
(via Object Inspector or Query Editor).

Then you see strings like these:

ITEMNAME=MYCOLUMN;MYCOLUMN DESC
and/or
ITEMNAME=MYCOLUMN

2. For the intended columns, change the strings to:

ITEMNAME=MYCOLUMN DESC;MYCOLUMN
and/or
ITEMNAME=MYCOLUMN DESC


Editing the OrderingItems is also very handy if you want to sort on
multiple columns. e.g.:

Class=CLASS,PUPIL;CLASS DESC,PUPIL DESC

sorts on CLASS, and within each class on PUPIL.


Hope this helps!

Paul Vinkenoog