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
Thanks...
Dan Rowe
Eagle Technology