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