Delete All Rows in a Simple Table (DriveWorks Documentation)

Delete All Rows in a Simple Table

This Specification Flow Task will delete all rows 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 DriveWorks Project Simple Table that will have its rows removed from.
Delete Header Row	TRUE to delete the header row, FALSE to delete everything except the header row.

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.

Delete All Example

Property Name	Example Rule	Example Result	Meaning
Simple Table Name	"MaterialCosts"	MaterialCosts	This is the name of the Simple Table to Delete all the Rows in.
Delete Header Row	TRUE	TRUE	This will delete all the rows including the headers.

Delete All Except Headers Example

Property Name	Example Rule	Example Result	Meaning
Simple Table Name	"MaterialCosts"	MaterialCosts	This is the name of the Simple Table to Delete all the Rows in.
Delete Header Row	FALSE	FALSE	This will delete all the rows but leave the headers.

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

All simple table rows were successfully deleted.

Success with Warnings

N/A - should never be fulfilled.

Failed (one of the following occurred)

Simple Table does not exist.
Specified Table name is not a Simple Table.
General failure - Check the Specification report for more details.

DriveWorks Pro 22 Delete All Rows in a Simple Table