Subject Re: Insert into a view
Author Adam
--- In, "emes01" <emes01@y...> wrote:
> Is it possible to insert data into a view
> I get a message telling me that the view is read only.
> any help would be great !!

What you have there is a read only view. You haven't given the
declaration, so it is guesswork why, but the usual culprits are views
that contain joins, unions, distinct, group by etc. Basically anything
other than a simple select from a single table is going to be read only.

You can make the read-only view updatable by creating triggers to
control exactly what you want the view to do before insert, update or

The Firebird Book contains a whole chapter on views, pp 493 - 496 are
of particular interest to you.