> Thanks for your input so far. But my point is that, according to the
> Firebird Book (my bible) states on page 493, that a view will be
> read-only if its SELECT statement has any of the following
> characteristics:
>
> * Specifies a row quantifier other than ALL ....
> * Contains fields defined by subqueries or other expressions
> * Contains Fields defined by aggregating functions....
> * Includes UNION ....
> * Joins multiple tables
> * Does not include all NOT NULL columns from....
> * Selects from a non-updateable view.
>
>
>
> My query has none of the above characteristics so I would expect it to
> be naturally updateable. I therefore assume this is a bug (which I have
> already entered into the tracker)

Support for the ORDER BY clause in a view DDL definition was an addition
in Firebird 2.1, so basically something new after the time of writing of
the book.



--
With regards,

Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!