| Subject | Prevent direct update from view |
|---|---|
| Author | Adomas Urbanavicius |
| Post date | 2005-06-06T09:36:13Z |
Hi,
Lets say I have view V1(RowX) (select RowX from TableX);
If I am updating RowX in view V1, it updates that row in table as well.
How can I prevent it ? (I need to fire my own trigger on view, but it
updates table, then fires triger)
Adomas
Lets say I have view V1(RowX) (select RowX from TableX);
If I am updating RowX in view V1, it updates that row in table as well.
How can I prevent it ? (I need to fire my own trigger on view, but it
updates table, then fires triger)
Adomas