Edit View Data

[Kirk Sherhart]

Is there any way to edit data from views (similar to tables) that have INSTEAD OF triggers for INSERT/UPDATE/DELETE? I know how to edit data from "simple" views, but I'm asking for a more generalized solution.

 

[Marco Kalter]

This is only possible for key-preserved views that can return a rowid.