Tech Tip: The "Reject NULL value input" Property
PRODUCT: 4D Developer | VERSION: 11 | PLATFORM: Mac & Win
Published On: December 12, 2007
The "Reject NULL value input" Property in a Field's Property List enables you to decide how 4D v11 SQL handles NULL values.
When the option is checked for a particular field, an error will occur when attempting to save a record that contains a NULL value in that field.
When the option is not checked, records with NULL values will not be rejected and can be added to the table.
When the option is checked for a particular field, an error will occur when attempting to save a record that contains a NULL value in that field.
When the option is not checked, records with NULL values will not be rejected and can be added to the table.