When new records are added to a database either by transactions or by a procedure’s NEW group, attributes not referenced are stored in the database with null values (case the attribute supports Nulls). In its navigation diagram, GeneXus indicates the list of attributes that will be inserted; those that do not appear in the list remain with null values.
This property avoids the situation described above. Upon activating it, the generators automatically initialize all attributes that were not referenced (in a transaction structure or a NEW group) with their corresponding Empty Value.
No | No action is taken. |
Use Environment property value |
Yes | The generators automatically initialize all attributes that were not referenced. |
- Long Varchar attributes are not initialized by this property, meaning that if a value is not assigned, it will remain as null. This exception is meant to reduce the space used by these types of attributes.
- If the value of this property changes, then you will need to force the generation of the program.
- The property at object level has priority over the one specified at Environment level.
To apply changes made by this property, do a Re-Build All.
Objects: Procedure, Transaction
Platforms: Web(.Net, Java)
Handling Nulls with GeneXus
Generate null for nullvalue() property
Nullable property - Attribute
Empty value for each DBMS/Data type