General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>In a view, does it make any difference whether the field (or fields) marked as "key fields" is included, or not, in the "updatable fields" list?
>>>
>>>(In my systems, in most cases the PK value is assigned through the field's "default value", and doesn't change later.)
>>
>>Hi Hilmar,
>>
>>If a field is not marked as an updatable then the view doesn't update it on the backend.
>
>Thanks. That is clear, but do you think that I SHOULD leave the key field it as not updatable (which seems to be the default)?
Hi Hilmar,
Why not? If you don't want this field to be updated on the backend (this includes INSERT scenario as well) then there is nothing wrong in leaving the field as non-updatable.
Thanks,
Aleksey.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only