This was a user contributed feature. I don't have plans to augment it
myself.
You are welcome to make the enhancements if you like.

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

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: <mmenaz@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, December 25, 2002 3:24 AM
Subject: [IBO] Re: Create Ordering Links creates using SingleSelect field
that won't work when


> 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