3. Using the Tables Utility : Create a Table : Column Specification—Defaults : How You Specify Standard Defaults
 
Share this page                  
How You Specify Standard Defaults
You can enter certain standard default instructions directly into the Defaults field, as described in the following table:
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.