Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
A view field that cannot be updated by the program
Message
De
18/02/2003 11:04:05
Mike Yearwood
Toronto, Ontario, Canada
 
 
À
18/02/2003 09:20:52
Information générale
Forum:
Visual FoxPro
Catégorie:
The Mere Mortals Framework
Divers
Thread ID:
00754437
Message ID:
00754482
Vues:
22
The safest way to write replace commands is like this...

REPLACE (fieldname) with (newvalue) IN (TARGETALIAS). Without the IN clause, you can be attempting to do a replace on the EOF record and that's why no change is made.

>I created a bizobj with only one view. I created my view from one table that has 3 fields. The two fields are updatable and the other one is my keyfield. But when I run my program and check the result of my table, the two updatable fields are not changed. I did debug my program and found out that right after my command "replace (fieldname) with (newvalue)", the value of the field doesn't change. However, if I do requery the view in the command window and use the same "replace" command, I can change the value of my field. What could be the possible reasons for this? If it has something to do with my bizobj, I can't see any problem because I only have one view and I know that it is the initial alias and thus is updatable.
>
>I will really appreciate any help.
>
>Thanks a lot.
>
>Nerissa
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform