>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