Home Search

DriveWorks Pro 21
Update Group Table Using Array

Send Feedback

Update Group Table Using Array

This Specification Flow Task will update a group table with the values from the given array.

Properties

Property NameDescription
Array ValueA table array value, such as the result of a QueryDataValues function.
Control Column NamesThe control column names (leave blank to append the data).
Control Columns determine how the data will be added to the Group Table. Do not confuse this property with a user form control.
Group Table NameThe name of the DriveWorks Group Table that the array value will be written to.
TitleChanges the Title (not the name) of the task.

Example

When this task is added the properties are static by default.
See How To: Change A Static Property To A Dynamic Property to enable rules to be built on these properties.

Property NameExample RuleExample ResultMeaning
Array ValueDWVariableCustomerData{"UserID","CustomerName";"10001","DriveWorks Ltd"}The Table Array that is being used.
Control Column Names"UserID"UserIDThe name of the Column which will be the Control.
Group Table Name"Customers"CustomersThe name of the Group Table that the Array will be Written too.

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

  • Successfully updated Group table from array provided.

Success with Warnings

  • N/A

Failed (one of the following occurred)

  • Table name was empty.
  • Table with name provided doesn't exist.
  • Given data was of an incorrect type.
  • General error - see Specification report for more information.