Subject Ordering in a grid derived from two tables
Author Russell Belding
Is it possible to set ordering items in a TIB_Query getting its dataset from
two tables?

I have, for example,
SELECT
A.APP_ID,
A.STAGE,
A.DOC_ID,
A.PRESENT_ORDER,
D.DOC_ID,
D.DOC_NAME,
D.DOC_PATH,
D.DOC_DESCRIPTION,
D.DOC_STATUS,
D.DOC_MACRO,
D.DOC_IX
from APP_DOC_LISTS A,
BCD_DOCUMENTS D where
A.APP_ID=32772
and A.STAGE=1
and A.DOC_ID = D.DOC_ID

The key links are
A.APP_ID
A.STAGE
A.PRESENT_ORDER

I want to allow users to order the rows in a TIB_Grid presented using
POrder=A.PRESENT_ORDER;A.PRESENT_ORDER DESC
Name=D.DOC_NAME; D.DOC_NAME DESC
Path=D.DOC_PATH; D.DOC_PATH DESC

and

A.PRESENT_ORDER=1
D.DOC_NAME=2
D.DOC_PATH=3

The grid column titles lack the ordering glyphs and ordering can't be done
pressing the column titles.
However the dataset ordering can be done by changing the OrderintItemNo
property.

I assume I have failed to set some required properties?

IBO3.6Dg , D5, Win2K.

Thanks

Russell