Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Key Values and Views
Message
From
08/08/1997 15:26:22
Larry Long
ProgRes (Programming Resources)
Georgia, United States
 
 
To
08/08/1997 15:19:37
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00043768
Message ID:
00043782
Views:
31
>>>>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?
L.A.Long
ProgRes
lalong1@charter.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform