Helen Borrie wrote:

>>I've just been stung again by some port problems which rely on ORDER BY
>>'alias'. Can't see anything in the roadmap, is this anywhere on in the
>>pipeline, or am I stuck with having to re-engineer the SQL for it via
>>ADOdb ?
>
> Can you not work with
> order by <degree-number>?
>
> The other option is
> order by <repeat-the-expression>

Not when every other engine accepts the alias, and the code is
configured to manage that including the ASC and DESC :(
I am going to add a check in the ADOdb sql handler to convert the alias
to a number for the firebird driver, but will slow down processing.

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