--- In firebird-support@yahoogroups.com, Allysson Costa
<allcostaes@...> wrote:

>
> Hi,
>
> When I try to create a view:
>
> CREATE VIEW ULT5_ALUNOS (AL_CODIGO, AL_NOME, AL_DTALTERACAO)
> AS
> SELECT FIRST 5
> AL_CODIGO,
> AL_NOME,
> AL_DTALTERACAO
> FROM ALUNO
> WHERE (AL_CODIGO<>0)
>
> I got this errorÇ
>
> Dynamic SQL Error SQL error code = -104 Token unknown - line 3, char

8 FIRST

>
> Why the FIRST word make error?
>

***Firebird 2.0.1*** release notes p19-20
-----------------------------------------

Extensions to CREATE VIEW Specification
D. Yemanov

FIRST/SKIP and ROWS syntaxes and PLAN and ORDER BY clauses can now be
used in view specifications.

From Firebird 2.0 onward, views are treated as fully-featured SELECT
expressions. Consequently, the clauses
FIRST/SKIP, ROWS, UNION, ORDER BY and PLAN are now allowed in views
and work as expected.


Adam