Subject | Re: [IBO] Another ordering queston |
---|---|
Author | Paul Vinkenoog |
Post date | 2003-01-13T11:05:16Z |
Hi Zile,
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
> I would like to set that first click on column header in gridI never tried this, but it seems to me that you ought to:
> 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 ?
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