>> Try to use column number instead of name, e.g. order by 5
>
>thank you.
>This works for the ORDER BY clause in my SQL.
>
>But it doesn't work for IBO. When I replace then column name
>with the column number in the OrderingItems, I get no longer
>a "column not found" error, but Ordering and Incremental
>Searching still don't work.
>
>Does IBO support Ordering and Incremental Searching on
>"subselected" columns?

It should (at least in my environment :)

E.g.

sql.text
select nr,
(select name from t_kunden k where k.nr=a.kdnr) as kname
from t_auftrag a

OrderingItems
Nr=1
KName=2

OrderingLinks
Nr=1
KName=2

Now you can click on title columns and "IncSearching" is working, too.

HTH,
Andreas