KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Tip: 'Map NULL values to blank values' also applies to external ODBC connections
PRODUCT: 4D | VERSION: 13.2 | PLATFORM: Mac & Win
Published On: February 15, 2013

The 'Map NULL values to blank values' option, which is found in the field Inspector window of the Structure editor, also applies to external ODBC connections served by the 4D Server

Typically this is used to extend the principle of using default values to all processing. Fields containing NULL values will be systematically considered as containing default values. For example, a Null date would become 00/00/00