SQL Special Fields
To do dynamic substitution of NULL fields with {{}}
, set the {{}}
value to __SQL_NULL__
.
E.g., Insert into Customers (LastName) Values ({{data.text0.input}})
would be the same as Insert into Customers(LastName) Values(NULL)
if {{data.text0.input}}
evaluated to __SQL_NULL__
.
Updated almost 4 years ago