Microsoft KB Archive/129537

= PRB: APPEND BLANK Fires Field-Level Validation =

Article ID: 129537

Article Last Modified on 8/25/1999

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition

-



This article was previously published under Q129537



SYMPTOMS
Issuing an APPEND BLANK on a table in which fields have validation rules may cause this error:

Field violation rule is violated.



CAUSE
The APPEND BLANK command adds blank values to all the fields of a new record, unless default values are specified. If a blank or default value in a field violates a validation rule, an message indicating the rule was violated will occur.



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.



STATUS
This behavior is by design.



Steps to Reproduce Behavior
Create a new database or open an existing database (.DBC file). Type the following commands in the Command window to create a one-field table (MyTable) and append a blank record: 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! When executing the APPEND BLANK command, Visual FoxPro attempts to store a blank value in cFld1. This violates the NOT EMPTY rule specified in the CREATE TABLE command, so a message indicating the rule violation occurs.

Additional query words: VFoxWin

Keywords: KB129537

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.