Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
The Mere Mortals Framework
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement