Get rid of the table alias stuff in the property settings. They are
preventing IBO from knowing which column is actually being referred to. I
don't want the expense of parsing for the table alias names you are using.

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/
>
>