"Douglas Dallacqua" <vdallacqua@...> wrote:

>
> CREATE VIEW VW_TEST(
> ID_TEST,
> NAME)
> AS
> select first 100 A,B from table;
>
> Error:
> Invalid token.
> Dynamic SQL Error.
> SQL error code = -104.
> Token unknown - line 3, char 8.
> first.
>
> On Firebird 1.03 and 2.0 Alpha 1 runs OK.

On FB 1.x a view is being created, but it ignores the FIRST/SKIP clause. I
think this is not what you'd expect. Hence this feature was disallowed in
v1.5. As for v2.0, it now works as expected.


Dmitry