Add Field Node with Node Action GetNewValue

To Add a Field Node with the GetNewValue Node Action

1. Right-click on the Table Node and select Add Field Node | GetNewValue. The Add Field pop-up window will be displayed.
2. In the Add field window:
   1. Select Field name from the Field name drop-down menu, which lists all of the columns with the Used property of the parent Table Node set to True.
   2. Select the DAL Component from the DAL components grid for the table from which you need to get the new value. Click the header to sort the column. You can select the DAL by scrolling to the desired entry or by typing the first letters of the DAL Component (this highlights the entry that starts with that letter). When the DAL Component is selected, the SelectBy methods available for the DAL Component are listed.
   3. In the DAL select methods grid, choose one SelectBy method and click OK.

      

      The Field Node and a child Table Node are added to the schema tree.

   4. The following properties, populated with the selected DAL Component information from the previous step, are displayed in the schema properties section.
      • DALAssemblyName
      • DALFactoryName
      • Name
      • NodeAction
      • SelectUniqueMethodName
      • SelectUniqueMethodParameters

      

3. Manually update the Annotation, Columns, FetchFieldName, MaxOccurs, MinOccurs, and NodeVariable properties, if required.
4. To view the properties of the Field Node:
   1. Select the Field Node. The properties of the Field Node are displayed in the schema properties. The Name and NodeAction are populated.
   2. Manually update the FetchFieldName, NodeVariable, and Optional properties if required.