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