PRB: APPEND BLANK Fires Field-Level Validation

RESOLUTION

Specify default values for fields that have validation rules, or set table buffering and Multilocks on before issuing an APPEND BLANK command. To enable buffering, open the table, and type the following commands in the Command window:

   SET MULTILOCKS ON
   =CURSORSETPROP("Buffering",n)  && n may be any value from 2 - 5.
					

See the Visual FoxPro Help menu for more information on the CURSORSETPROP() function.

To achieve buffering through the Visual FoxPro interface, choose Options from the Tools menu. Then select the Data tab. Under the Locking and Buffering section, place a chack mark in the Multiple Record Locks check box to set multilocks on. Set Buffering to any setting except Off.

   SET MULTILOCKS OFF
   CREATE TABLE MyTable (cFld1 C(10) CHECK !EMPTY(cFld1))
   =CURSORSETPROP("buffering",1)
   APPEND BLANK                      && The message appears!
   SET MULTILOCKS ON
   =CURSORSETPROP("buffering",2)
   APPEND BLANK                      && The record is appended, no message!