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

Click here to load this message in the networking platform