Hi List,

I use a TIB_Grid in wich one of the columns is a TIB_LookupCombo. The contents of the combo are selected through the TIB_Query linked:

select v.cod_id,
v.cli_id,
(select c.nome from clientes c where (c.cli_id = v.cli_id) as cli_descr, // combo
from vendas v
order by v.cod_id desc
for update

The column cli_descr is one of the OrderingItems of the query. It is shown correctly in the grid, but does not accept the click on the title to change order.

The error message:

"Project Bean.exe raised exception class EIB_ISCError with message 'ISC ERROR CODE: 335544569

ISC ERROR MESSAGE:
Dynamic SQL error
SQL error code = -206
Column unknown
CLI_DESCR
At line 27, column 20.
'. Process stopped. Use step or run to continue."

Am I doing somethig wrong or it is not possible to order by columns like this ?

Thanks in advance,

RMiranda







____________________________________________________________________________________
Novo Yahoo! Cadê? - Experimente uma nova busca.
http://yahoo.com.br/oqueeuganhocomisso

[Non-text portions of this message have been removed]