>>>>>>I have been trying to add and update information using views, but had reached a stumbling block. When I added a record to a view with buffering on and all the cursorsetprop() properties set properly, all the fields get updated to the parent table except the keyfield. The keyfield shows ok in the view but the actual table shows blank.
>>>>>>
>>>>>>The fix that I found was to use the default setting in the table designer to automatically assign the keyfield value. I am using dtos(date())+sys(2015).
>>>>>>
>>>>>>I think that the problem I had should qualify as a bug. When a view is updating to the table, it should use the oldval('keyfield") to do the record search and then update it with the new value.
>>>>>>
>>>>>>Hope this helps. I would appreciate any comments as to other solutions.
>>>>>
>>>>>Could it be, that you forgot to check updatable option for key field in the last page of View designer (it's a common mistake).
>>>> I set =cursorsetprop('updatable')
>>>>Have you tried modifying a key value in a view?
>>>
>>>I check the option, and it helps to save new key value. I hope this is the answer on your implicit warning.
>>I created the view thru code and set the corsorsetprop() properties. When I weny into the view designer the keyfield was not marked as updateable. Is there a way to set it programatically?
>
>CursorSetProp("UpdatableFieldList")
Thanks