Setting an Element Explicitly to Nil
In some situations, you may wish to set an element explicitly to nil. One situation is when you wish to insert a row into a database table and you wish to supply a NULL for one of the columns. To set an input element explicitly to nil, perform the following:
Procedure
-
Select the input element you wish to set to nil.
-
Click Edit Statement on the Input tab toolbar.
-
Click the Content tab of the Edit Statement dialog.
-
Select the checkbox in the Set Explicit Nil field.
The element’s formula becomes blank and uneditable (because nil is the value of the element) and the explicit nil qualifier icon appears next to the statement.