General information
Category:
Coding, syntax & commands
Title:
VFP 5.0 - Buffering Error Message
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-
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only