It's a (very annoying) bug of the automatic ordering creation button.
The problem is that with columns alias the "ORDER BY" does not work,
you have to provide "column ordinal number" (i.e. 1,2,3).
So for OrderingItems you must have:
B_Name=3
while for OrderingLinks, the alias column name is recognized so you
must have:
B_Name=ITEM=1

Hope that Jason will fix this, since automatic ordering creation is
very useful, and often I forget about alias and my wuery crashes at
runtime when the user changes order :(
regards
Marco Menardi

--- In IBObjects@yahoogroups.com, Raymond Kennington <progsol@c...> wrote:
> Create Ordering Links creates using SingleSelect field that won't
work when run.
>
> Example:
>
> 2 tables:
>
> A
> ID NOT NULL
> NAME NOT NULL
> BID NOT NULL REFERENCES B(ID)
> PrimaryKey: ID
>
> B
> ID NOT NULL
> NAME NOT NULL
> PrimaryKey: ID
>
> SELECT
> A.ID,
> A.NAME,
> (SELECT B.NAME from B WHERE B.ID = A.BID) AS B_Name
> FROM A
>
> B_Name=B_Name
> and
> B_Name=ITEM=1
>
> which is acceptable to the TIB_Query control, but, when run,
produces a error of
> column unknown.
>
> The following SELECT statement is also invalid:
>
> SELECT
> A.ID,
> A.NAME,
> (SELECT B.NAME from B WHERE B.ID = A.BID) AS B_Name
> FROM A
> ORDER BY B_Name
>
> and this indicates that TIB_Query should not have
>
> (a) provided B_Name in the list of possible fields for creating
ordering links;
>
> (b) created the Ordering Link;
>
> (c) accepted the Ordering Link.
>
>
>
> --
> Raymond Kennington
> Programming Solutions
> W2W Team B