Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only