You cannot force a subselect to be used in dataset refinement.
Remove the POS attribute and see what happens.

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

----- Original Message -----
From: <guido.klapperich@...>
To: "IBObjects" <IBObjects@yahoogroups.com>
Sent: Friday, November 09, 2001 5:39 AM
Subject: [IBO] OderingLinks and SubSelect


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