HOWTO: Set Buffering Mode in Visual FoxPro

ID: Q128205

The information in this article applies to:

SUMMARY

Data buffering is used in Visual FoxPro to enable edits to be made and verified in memory before they are applied to a .DBF file and to handle some record contention issues in a multiuser environment. There are several ways to use buffering within Visual FoxPro. This article gives you an overview.

MORE INFORMATION

There are two ways to set the buffereing mode. Issue a SET MULTILOCKS ON, or choose the Multiple Record Locks check box in the Data Tab of the Tools, Options dialog to begin buffering data. Use one of the following methods to set the buffering mode.

Setting the Buffering Mode Through the Visual FoxPro Interface

Use any one of the following methods to set the buffering mode through the Visual FoxPro user interface:

NOTE: You cannot set a default buffering mode for a table through the Database Designer.

Setting the Buffering Mode Programatically

To set the buffering mode programatically, you can use the CURSORSETPROP() function to enable or disable buffering on an open table. The following line of code sets Optimistic Row buffering:

   SET MULTILOCKS ON
   =CURSORSETPROP("Buffering",3)

You must issue this line of code for each open table on which you wish to enable buffering. This command overrides the default BufferMode property on a form, or the default BufferModeOverride property for a cursor in the Data Environment for the Form.

REFERENCES

For more information on the properties and functions used in this article, please see the Visual FoxPro Language Reference. For information on using the Forms Designer, please see the Visual FoxPro User's Guide.

Additional query words:

Keywords          : kbMAC kbVFp kbVFp300 kbVFp600 FxprgMultiuser 
Version           : 3.0,6.0
Platform          : MACINTOSH WINDOWS

Last Reviewed: November 2, 1998