Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
A view field that cannot be updated by the program
Message
From
18/02/2003 09:47:38
 
 
To
18/02/2003 09:20:52
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Miscellaneous
Thread ID:
00754437
Message ID:
00754448
Views:
21
>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.

A couple thoughts to check:
In the view's Update Criteria, do you have Send SQL Updates checked? What is the SQL Where Clause setting? Is your primary key field updatable? Do you have code in the Save() method without a DODEFAULT?

Chris.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform