| Subject | Re: Insert into a view |
|---|---|
| Author | Adam |
| Post date | 2005-11-11T05:01:28Z |
--- In firebird-support@yahoogroups.com, "emes01" <emes01@y...> wrote:
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
delete.
The Firebird Book contains a whole chapter on views, pp 493 - 496 are
of particular interest to you.
Adam
>What you have there is a read only view. You haven't given the
> 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 !!
>
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
delete.
The Firebird Book contains a whole chapter on views, pp 493 - 496 are
of particular interest to you.
Adam