I have the following Query:
select CTID,
....
(select CSDANAME1 from CUSTOMERS where
CONTACTS.CTCSID=CSID) as CTCSNAME,
....
CTCHILDREN from CONTACTS

OrderingItems:
Customer=6;6 DESC (6 is the position of CTCSNAME)

OrderingLinks:
....
CTCSNAME=ITEM=3;POS=0
....

When I set OrderingItemNo:=3, I get the error 'Column unknown: CTCSNAME'

Any ideas ?


Guido