> Traced it in monitor and found out that IBO sends into server the SQL where only message.ID is asked
>
> SELECT messages.ID from....
>
> Thats why the ORDER BY 3 gives error, other columns have fieldnames and ORDER BY DOCNO workes OK.
> Further experimenting showed that this SQL contains fields in KeyLinks.
>
> Does this mean that I have to add 2 dummy keylinks entries?
>
> IMVHO this can be considered as a tiny bug.

I've played with a couple of tables here and everything
looks fine, but your select SHOULD have all the fields you
ask for so perhaps we need Jason to fill in what we are both
missing :)

In the meantime what happens if you move the accountno field
to be the first one so you are using ORDER BY 1 ? ( move ID
to the end of the list so the select has to have the other
fields first )

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services