Subject Problem with OrderingLinks/Items/etc.
Author Salvatore Besso
hello all,

I have a problem when I click on the header of the grid to change sort order.

The main query (bound to DirDS datasource):

SQL:

SELECT D.PREFIX, D.UNIT, D.CALL_SIGN, D.OPERATOR_NAME,
D.TX_PROVINCE,
(SELECT P1.SHORT_NAME FROM PROVINCES P1 WHERE P1.ID_PROVINCE = D.TX_PROVINCE) AS
TX_PROV,
D.OWN_PROVINCE,
(SELECT P2.SHORT_NAME FROM PROVINCES P2 WHERE P2.ID_PROVINCE = D.OWN_PROVINCE)
AS OWN_PROV,
D.REDUCED, D.EXCLUDED, D.FIRST_TWENTY FROM DIRECTORY D
ORDER BY D.PREFIX, D.UNIT

OrderingItems:

CALLSIGN=PREFIX,UNIT;PREFIX DESC,UNIT DESC
OPERATOR_NAME=OPERATOR_NAME,PREFIX,UNIT;OPERATOR_NAME DESC,PREFIX DESC,UNIT DESC
TX_PROV=TX_PROV;TX_PROV DESC
OWN_PROV=OWN_PROV;OWN_PROV DESC
REDUCED=REDUCED,PREFIX,UNIT;REDUCED DESC,PREFIX DESC,UNIT DESC
EXCLUDED=EXCLUDED,PREFIX,UNIT;EXCLUDED DESC,PREFIX DESC,UNIT DESC
FIRST_TWENTY=FIRST_TWENTY,PREFIX,UNIT;FIRST_TWENTY DESC,PREFIX DESC,UNIT DESC

OrderingLinks:

CALL_SIGN=ITEM=1
OPERATOR_NAME=ITEM=2
TX_PROV=ITEM=3
OWN_PROV=ITEM=4
REDUCED=ITEM=5
EXCLUDED=ITEM=6
FIRST_TWENTY=ITEM=7

The two Provinces tables:

P1:

KeyLinks: ID_PROVINCE=DIRECTORY.TX_PROVINCE
KeyDescLinks: SHORT_NAME=TX_PROV
KeySource: DirDS
OrderingItems: SHORT_NAME=SHORT_NAME;SHORT_NAME DESC (to use a LookupCombo in
another form)
OrderingLinks: SHORT_NAME=ITEM=1

P2:

KeyLinks: ID_PROVINCE=DIRECTORY.OWN_PROVINCE
KeyDescLinks: SHORT_NAME=OWN_PROV
KeySource: DirDS
OrderingItems: SHORT_NAME=SHORT_NAME;SHORT_NAME DESC (to use a LookupCombo in
another form)
OrderingLinks: SHORT_NAME=ITEM=1

When I click on the grid header (item 3 or 4) I get an error -206 with message

"Field TX_PROV unknown" (item 3)
"Field OWN_PROV unknown" (item 4)

What am I missing? Otherwise, the query works fine until I click on that
columns. The other OrderingItems work fine also.

Thanks
Salvatore