It should work...
Use SQLMOnitor to see what's sent to the server when you click on the
column grid (pay attention at what "order by" is sent).

just to do some experimenti...

Try
OrderingLinks:
A.NAME=ITEM=1
A.STROKE=ITEM=2
A.S_CODE=ITEM=3

or try
OrderingItems:
HERBAL_NAME=2
H_STROKE=3
H_CODE=4

but it should work as you set it up...


Are you SURE data order does not change? Or you have a IB_Query
RefreshAction set to KeepDataPos and in a big dataset you don't see
the sort is changed?

regards
Marco Menardi

--- In IBObjects@yahoogroups.com, "kj01135 <kj01135@y...>"
<kj01135@y...> wrote:

> I have a IB_Query which links up with 3 different table and setup
> the orderingitems accordingly. However the orderingitems does'nt
> seem to work. Please help.
>
> SELECT H.REFNO
> , A.NAME
> , A.STROKE
> , A.S_CODE
> , H.DOSAGE
> , H.CHARACTERISTIC
> , H.SYSTEM
> , H.FUNC
> , H.USES
> , H.REMARK
> FROM HERBAL H
> RIGHT JOIN HERBAL_WITH_CAT HC
> ON HC.H_REFNO = H.REFNO
> JOIN ALL_HERBAL A
> ON A.REFNO = H.REFNO
>
> The Plan is:
> PLAN MERGE (SORT (A ORDER X_ALL_HERBAL_SCODE),SORT (JOIN (HC
> NATURAL,H INDEX (RDB$PRIMARY3))))
>
> The Keylinks are HERBAL.REFNO and ALL_HERBAL.NAME which is the
> primary key for table HERBAL and table ALL_HERBAL respectively.
>
> The OrderingItems is:
> HERBAL_NAME=ALL_HERBAL.NAME
> H_STROKE=ALL_HERBAL.STROKE
> H_CODE=ALL_HERBAL.S_CODE
>
> The OrderingLinks is:
> NAME=ITEM=1
> STROKE=ITEM=2
> S_CODE=ITEM=3
>
> The OrderingItemNo is 3.
>
> When I open the dataset inside IB_Query editor, the data display
> propertly but when I click the data grid title on one of the
> ordering fields to change the ordering, nothing happen but I can
> still see the glyph is displayed next to it. What's wrong?
>
> I am using Firebird 1.0 and IBObjects 4.2.Ia.
>
> Regards,
> Kenneth Man