Subject | Again on the updatable views with triggers |
---|---|
Author | Marco Lauria |
Post date | 2001-11-26T17:44:26Z |
Hi All,
I thought about this problem and I think that the solution can be
to return 1 in rows affected for both the insert and update command against
a view
instead of zero.
Infact I think that even if the insert or the update are spawn across
several tables,
the result for the view is that the row with which we are dealing is
inserted and / or updated.
Also this can solve the problem with IBO.
What do u think?
regards
Marco
I thought about this problem and I think that the solution can be
to return 1 in rows affected for both the insert and update command against
a view
instead of zero.
Infact I think that even if the insert or the update are spawn across
several tables,
the result for the view is that the row with which we are dealing is
inserted and / or updated.
Also this can solve the problem with IBO.
What do u think?
regards
Marco