Please enable JavaScript to view this site.

Altova MapForce 2020 Enterprise Edition

Used to set a database column to null. This function will also overwrite a default value with null. If connected to something else i.e. not a database field, it will behave like an empty sequence.


Please note:


Connecting set-null to a different function will usually result in the other function not being called at all. Connecting set-null to a sequence function, e.g. count, will call the function with an empty sequence.

Connecting to special functions, Filters and IF-Else conditions works as expected, fields are set to null. For filters this means the "node/row" input.

Using set-null as an input for a simpleType element will not create that element in the target component.

© 2020 Altova GmbH