The information in this article applies to:
SYMPTOMSIssuing an APPEND BLANK on a table in which fields have validation rules may cause this error:
CAUSEThe 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. RESOLUTIONSpecify 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:
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. STATUSThis behavior is by design. MORE INFORMATIONSteps to Reproduce BehaviorCreate 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:
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 : FxprgTable |
Last Reviewed: August 24, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |