Subject Re: [firebird-support] ORDER BY 'alias'
Author Lester Caine
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