This question regards a project which uses related tables on a form. Each form has 'buffering mode-optimistic', and each table belongs to a single database. The form has worked well, using =tableupdate() and =tablerevert().

As part of the data processing, code has been written to move data from one table to another, such as

use master
append from holder

Recently I have begun to get the error message "Command cannot be issued on a table with cursor in table buffering mode". It has been resolved by the command =cursorsetprop("buffering",3).

In addition to a technical explanation of what is occuring, and where a table 'holds' buffering information, I am also concerned that I am trying to do something to a table while there is NEW data in a cursor waiting to be added to it. Do I need something like a 'commit' statement (which I think was a CLIPPER command).

Thanks for any thoughts-