I have found that none of the following combinations of configurations sets the field to Null:
Expression : IIF(1 = 1 , Null, Null) => this results in an empty string instead of Null. Log file looks fine with no errors
Log File :
Trying: EXPRESSION
Checking to verify there is a field to store the expression
Expression to be eval: iif(1 = 1,Null,Null)
Setting Value to:
Finished: EXPRESSION
-----
Expression : IIF(1 = 1 , <Null>,<Null>) => this does nothing as it is considered syntactically incorrect as per log file:
Log File :
Trying: EXPRESSION
Checking to verify there is a field to store the expression
Expression to be eval: iif(1 = 1,<Null>,<Null>)
ERROR: evaluating the expression for feature in AA_VOne with OID of 1
Syntax error
Finished: EXPRESSION
-----
Expression : IIF(1 = 1 , "", "") => this results in an empty string instead of Null which doesn't align with the online reference in my previous post above. Log file looks fine with no errors:
Log File :
Trying: EXPRESSION
Checking to verify there is a field to store the expression
Expression to be eval: iif(1 = 1,"","")
Setting Value to:
Finished: EXPRESSION
----
Expression : IIF(1 = 1 , vbNull, vbNull) => this results in the value of the vbNull which is 1 string instead of Null. Log file looks fine with no errors
Log File :
Trying: EXPRESSION
Checking to verify there is a field to store the expression
Expression to be eval: iif(1 = 1,vbNull,vbNull)
Setting Value to: 1
Finished: EXPRESSION
-----
Expression : IIF(1 = 1 , <Null>,<Null>) => this does nothing as it is considered syntactically incorrect as per log file:
Log File :
Checking to verify there is a field to store the expression
Expression to be eval: <Null>
ERROR: evaluating the expression for feature in AA_VOne with OID of 1
Syntax error
Finished: EXPRESSION