Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Key Values and Views
Message
De
08/08/1997 15:04:38
 
 
À
08/08/1997 14:58:17
Larry Long
ProgRes (Programming Resources)
Georgie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00043768
Message ID:
00043771
Vues:
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).
Edward Pikman
Independent Consultant
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform