Skip to content

Allow_Blank_State - ValidationTable

Controls whether blank entries are accepted in this object

Type: Property
Access: Read/Write
Data Type: Integer
Parameters: None

Syntax

Property Integer Allow_Blank_State
Access Type Syntax
Read Access: Get Allow_Blank_State to IntegerVariable
Write Access: Set Allow_Blank_State to IntegerVariable/Value

Description

If Validate_State is True, Allow_Blank_State controls whether blank entries are accepted in this object. If Validate_State is False, Allow_Blank_State has no effect.

Default is False.

Allow_Blank_State only works with ASCII columns. If your column is numeric, consider augmenting the function Validate_Value in the FileValidationTable object like this:

Function Validate_Value String sCode Returns Integer
    Integer iErr
    If (sCode = "0") Move "" to sCode
    Forward Get Validate_Value sCode to iErr
    Function_Return iErr // 0=OK
End_Function