Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What am I doing wrong
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00433820
Message ID:
00433821
Views:
11
>Im trying to update a table using tableupdate().
>I created a parameterized view from a table in my dbc. on the form page I have successfully been able to give the user a blank record to start and then do a lookup into the table the view is created from after they do that lookup I use the key field they picked as the parameter for my view. They can also skip through the main table which updates the screen via requery().The problem is when I try to tableupdate() or tablerevert() the changes are not in both cases saved to the main table also if I then skip or skip-1 the rest of the record have the same data as it was changed durring the edit. The buffermodeoverride on both the table and view are set to 3 and the buffermode in form is set to 2.I also have a cursorsetprop("Buffering",3) in the forms init else I get an error when trying to tableudate or revert that sez 'function requires row or table buffering mode'
>
>any thoughts or help please

I am having trouble following what you are doing. Is there any way you could rephrase your problem? One thing will views is that if the underlying table of a view is also buffered, then you also have to issue a tableupdate on the table. In other words, the tableupdate on the view save the changes to the buffered table, which also needs a tableupdate to get the data written to disk.
Chris McCandless
Red Sky Software
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform