Update A Single Value In A Simple Table (DriveWorks Documentation)

Update A Single Value In A Simple Table

This Specification Task will update a single value in a Simple Table.

Properties

Property Name	Description
Title	Changes the Title (not the name) of the task.
Simple Table Name	The name of the Simple Table in which the cell will be updated.
Column Number	The column number of the cell to be driven.
Row Number	The row number of the cell to be driven (row 1 is the table header row).
New Value	The value to be driven into the specified cell.

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 Name	Example Rule	Example Result	Meaning
Simple Table Name	Employees	Employees	Will update the cell in the table Employees.
Column Number	3	3	Will update the cell in the third column (Age).
Row Number	4	4	Will update the cell in the fourth row (the header row is always the first row).
New Value	26	26	Will replace the current value with 26.

Example Data

This is an example list of employees details stored in a Simple Table named Employees.

FirstName	SecondName	Age
John	Smith	34
Sally	Coates	31
Ollie	Jarvis	25

Example Result

This is the example result showing the SecondName of the second entry changed from Coates to Jones.

FirstName	SecondName	Age
John	Smith	34
Sally	Jones	31
Ollie	Jarvis	26

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

Value was successfully set.

Success with Warnings

N/A - should never be fulfilled.

Failed (one of the following occurred)

Invalid row number.
Invalid column number.
Invalid simple table or does not exist.
General failure - Check the Specification report for more details.

DriveWorks Pro 22 Update A Single Value In A Simple Table