KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
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.