Article ID: 195408 - View products that this article applies to.
This article was previously published under Q195408
Specifying the keyfield of a View sets the rest of the fields to be updateable, although the fields are not being set to be updateable explicitly.
Use a DBSETPROP() command similar to the following to clear the fields in the view that you do not want to be updateable:
Also, you can open the view in the View Designer and clear the fields that you do not want to be updateable, from the Update Criteria tab.
Microsoft is researching this behavior and will post new information here in the Microsoft Knowledge Base as it becomes available.
Steps to Reproduce BehaviorCreate and run a program with the following code:
If the table for which the view is being created has a primary key, then that field is set as the keyfield automatically when the view is created. The following code reproduces this behavior:
Note that both of the DBGETPROP() commands return .T., meaning that both of the fields are updateable.
Article ID: 195408 - Last Review: May 12, 2003 - Revision: 2.1