Home Search

DriveWorks Pro 21
Update Column Data in a Simple Table

Send Feedback

Update Column Data in a Simple Table

This Specification Flow Task will update a column value in a Simple Data Table with a Constant value.

Properties

Property NameDescription
TitleChanges the Title (not the name) of the task.
Column NumberThe column number whose data will be updated.
New Column ValueThis value will be calculated for the current row, which is written to the Row Number Constant.
Simple Table NameThe name of the DriveWorks Project Simple Table in which the column data will be updated.
Row number ConstantThe Constant that the row number will be written to.

Example

When this Task is added the properties are static. To be able to build rules on a static property see How To: Change A Static Property To A Dynamic Property.

Property NameExample RuleExample ResultMeaning
Column Number22This will select column three to insert the new values for.
New Column Value"Aluminum"AluminumThis is the new value that will be inserted for all the rows in the specified column
Simple Table Name"ManufacturingDetails"ManufacturingDetailsThis is the name of the Simple Table that you want to update the values for.
Row Number Constant"DWConstantAffectedRows"DWConstantAffectedRowsThis is the name of the Constant that will report back with how many rows were affected by the task.

Example Data

PartMaterialQuantity
Beam 200x400Stainless Steel2
Corner Bracket LargeStainless Steel4
Beam 200x200Stainless Steel6

Example Result

PartMaterialQuantity
Beam 200x400Aluminum2
Corner Bracket LargeAluminum4
Beam 200x200Aluminum6

Using the Task in a Specification Macro

This task has different types of Outputs. For more information about Outputs see Specification Macros Task Node.

Outputs are only available within Specification Macros. Currently Outputs are not available for Specification Flow.

Status Outputs

This task supports Status Outputs. These can be used to perform different actions depending on what the status outcome of the task is. For more information see Status Outputs in the Task Node Outputs section of Specification Macros Task Node.

The status output navigation is as follows:

Success

  • Simple Table updated successfully

Success with Warnings

  • N/A - should never be fulfilled

Failed (one of the following occurred)

  • Table name field cannot be left empty
  • Simple Table does not exist
  • Specified table isn't a Simple Table type
  • Data specified inside Simple Table row is not an array type
  • Column number field cannot be left empty or be less than 0
  • Row number field cannot be left empty or be less than 0