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.

Also, when i try to pass some scripts to database in 1.5 i get the
error
Dynamic SQL Error
SQL error code = -104
number of page buffers for cache required

and

SQL error code = -104
number of page buffers for cache required
SQL warning code = 301
DATE data type is now called TIMESTAMP

But in 1.0x all runs ok and of course i'm using dialect 1


Thanks