One thing I spotted real quick was you have done an IBO No-No. You put JOIN
criteria in your where clause.
You should either put it in the JoinLinks property or use declarative JOIN
syntax with the ON clause.

As for ordering, you should be able to do it as you are wanting. If you want
the glyphs you need to make sure your OrderingLinks are setup properly.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Russell Belding" <russell@...>
To: <IBObjects@yahoogroups.com>
Sent: Saturday, July 28, 2001 3:41 AM
Subject: [IBO] Ordering in a grid derived from two tables


> 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
>
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>