Subject Re: [firebird-support] Updatable views on join tables
Author unordained
---------- Original Message -----------
From: "sqlsvr" <sqlsvr@...>
> It looks like firebird does not support updateable views that have
> join tables. Is there any way to implement a view that has one or more
> inner joins and is updatable?
------- End of Original Message -------

Firebird requires you to create your own instead-of triggers for views that it
cannot automatically make updateable, yes, and joins are not considered
automatically updateable. The syntax for this is the same as for triggers on
tables, no "INSTEAD OF" syntax as in SQL Server. They'll need to be BEFORE
triggers, as I recall.

-Philip