"Configuring TIB_LookupCombo" (From IBO.Hlp)
Table Produce:
Name – A(20) Table ProduceType:
Type – A(4) <----------------> Type – A(4)
Description – A(40) Description – A(30)
Price – N(15, 4)
Qty – I

Teble produce SELECT
SELECT
NAME,
(select DESCRIPTION from PRODUCETYPE T
where T.TYPE = P.TYPE) as TYPE_DESC,
DESCRIPTION,
PRICE,
QTY
from PRODUCE P

1.- Achieved lookupCombo working ok inside the Grid.
2.- Using the description (TYPE_DESC) as an ordering field
3.- I get the following error message when prepare:
SQL error code= -206
Column unknown
TYPE_DESC

i´m clueless. need advice
thanks in advance
8-|