And what about date and timestamp error with dialect 1?

Thankds

--- In firebird-support@yahoogroups.com, "Arno Brinkman"
<fbsupport@...> wrote:

>
> Hi,
>
> > I have a database with a lot of stored procs. I have moved from

firebird

> > 1.0x to 1.5 and when i try to recompile some stored procs i get

the error

> > Invalid expression in the ORDER BY clause (not contained in

either an

> > aggregate function or the GROUP BY clause)
>
> > The expression is
>
> > select max(NFIELD)
> > from Table_X
> > where IDTABLEX = :IDTableX
> > order by IDTABLEX, NFIELD
> > into :NField;
>
> > in previous versions i used the order by clause to force index
> > selection, but do i have now to change all the metadata to make

it

> > compatible with 1.5x.
>
> The error is correct, because IDTABLEX isn't a valid field in your

query.

> The ORDER is done after the aggregate-calculation and at that

point there can be more IDTABLEX values for NFIELD.

> With other words such a query in FB1.0 could give you wrong

results.

>
> Regards,
> Arno Brinkman
> ABVisie
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> General database developer support:
> http://www.databasedevelopmentforum.com
>
> Firebird open source database (based on IB-OE) with many SQL-99

features:

> http://www.firebirdsql.org
> http://www.firebirdsql.info
>
> Support list for Interbase and Firebird users:
> firebird-support@yahoogroups.com
>
> Nederlandse firebird nieuwsgroep:
> news://newsgroups.firebirdsql.info
>