Read-only Views

From InterBase
Jump to: navigation, search

Go Up to Granting Access to Views


When a view definition contains a join of any kind or an aggregate, it is no longer a legally updatable view, and InterBase cannot directly update the underlying tables.

Note: You can use triggers to simulate updating a read-only view. Be aware, however, that any triggers you write are subject to all the integrity constraints on the base tables. To see an example of how to use triggers to “update” a read-only view, see Updating Views with Triggers.

For more information about integrity constraints and triggers, see Working with Triggers.

Advance To: