Helen Borrie wrote:

> It would take compelling reasons for Firebird to "someday support" syntax
> that isn't standard-compliant. "Compelling reasons" would no doubt include
> future changes to the standard.

It is one of the major problems when porting code from MySQL or Postgres
to Firebird. Hacking the ADOdb layer to make things work is only
practical some of the time. So OK it does not follow the standard, but
it does make logical sense when you want a 'sort by X' at the PHP level,
and have 'generated' X within the SQL.

Is it that difficult to track alias vs. column number in the engine?
It's a bit of a pig when the SQL is generated from sections and
assembled into a working query in the PHP level ;)

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