SET AUTONULLFIELDS

Topic group Related topics

Global setting used to affect the status of fields in blank records when APPENDing to a Level 7 database.

Syntax

SET AUTONULLFIELDS ON | off

Description

Use SET AUTONULLFIELDS to determine whether empty fields are assigned a NULL value, or when applicable, filled with spaces, zero or "false".

When AUTONULLFIELDS is ON (the default setting), dBASE Plus allows an empty field to assume a “null value”. Null values are those which are nonexistent or undefined. Null is the absence of a value and, therefore, different from a blank or zero value.

When AUTONULLFIELDS is OFF, numeric fields (long, float, etc.) are assigned a value of zero, logical fields a value of "false", and character fields are filled with spaces.

OODML

Use the rowset object's autonullFields( ) property. This property will override the global setting.