Hi,

> Does anyone know why Firebird 1.5 gives the error:
> Dynamic SQL Error
> SQL error code = -104
> Invalid expression in the ORDER BY clause (not contained in either an
> aggregate function or the GROUP BY clause)

You should only see this error when you've an aggregate-query with an
incorrect ORDER BY clause, but the query posted isn't a aggregate-query at
all, so this is a little weird. Are you sure this is the problematic query?
Do you get the same problem when you run it inside a DB-Tool (ISQL,
IBOConsole, DBW, IBExpert, etc...) ?

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Interbase and Firebird users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://80.126.130.81