Nulls Field | Defaults Field | Results if User Does Not Enter Data |
Yes | yes | Enters a null value in the data column. |
Yes | no | Requires a user to enter data in this column. User can explicitly specify a null value. Any QBFor VIFRED form created from this table can have the Mandatory attribute set for this data column. |
No | yes | Enters a default value as follows: Numeric column = 0 Variable‑length character column = string of zero length Fixed‑length character column = blanks Date column = empty date User cannot enter an explicit null value. |
No | no | Requires a user to enter data in this column. User cannot enter a null value. Any QBFor VIFRED form that is created from this table can have the Mandatory attribute set for this data column. |
Yes | null | Enters a null value in the data column. |
No | null | Not allowed. |
Yes | user | Enters the username of the runtime user in the data column if no value is explicitly specified. User can explicitly specify a null value. |
No | user | Enters the username of the runtime user in the data column. User cannot enter an explicit null value. |
Yes | value | Enters a user‑defined default value created with the EditDefaults operation. |
No | value | Enters a user‑defined default value created with the EditDefaults operation. |