Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updatable fields
Message
From
26/05/2004 15:26:59
 
 
To
26/05/2004 14:46:20
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00907165
Message ID:
00907511
Views:
10
This message has been marked as a message which has helped to the initial question of the thread.
>>>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
Map
View

Click here to load this message in the networking platform