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.
Procedure
-
Select the input element you wish to set to nil.
Click the
Edit Statement
icon (XPath 1.0) or
Show/Hide Edit Tab
icon (XPath 2.0) on the
Input tab toolbar.
-
(XPath 1.0) Click the Content tab of the Edit Statement window and select the
Set Explicit Nil check box.
The element’s formula becomes blank and is not editable (because nil is the value of the element) and the explicit nil qualifier icon appears next to the statement

.
-
(XPath 2.0) Select the
Set Explicit Nil check box under the
Statement Type section under the
Edit Statement tab.
Copyright © TIBCO Software Inc. All Rights Reserved.