Subject | Naturally updatable views |
---|---|
Author | willhonor |
Post date | 2009-02-18T18:14:38Z |
Hello,
I'm after some clarification about something I have read in the
firebird book. It says that views are not naturally updatable if the
view does not select all of the not null fields in a table. Is that
strictly true? I'm just starting to use views and it seems that if the
field that is not included in the view is updated by a default value or
a trigger then the view will still be updatable.
Am I correct on this or am I likely to get bitten further down the
line?
Thanks,
Will.
www.cohesis.co.uk <http://www.cohesis.co.uk>
[Non-text portions of this message have been removed]
I'm after some clarification about something I have read in the
firebird book. It says that views are not naturally updatable if the
view does not select all of the not null fields in a table. Is that
strictly true? I'm just starting to use views and it seems that if the
field that is not included in the view is updated by a default value or
a trigger then the view will still be updatable.
Am I correct on this or am I likely to get bitten further down the
line?
Thanks,
Will.
www.cohesis.co.uk <http://www.cohesis.co.uk>
[Non-text portions of this message have been removed]