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
  1. 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.

  2. (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

    .
  3. (XPath 2.0) Select the Set Explicit Nil check box under the Statement Type section under the Edit Statement tab.