PRB: APPEND BLANK Fires Field-Level Validation (129537)
The information in this article applies to:
- Microsoft Visual FoxPro for Windows 3.0
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 <fieldname> 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.
Modification Type: | Major | Last Reviewed: | 8/25/1999 |
---|
Keywords: | KB129537 |
---|
|