Home Search

DriveWorks Pro 21
Delete All Rows in a Simple Table

Send Feedback

Delete All Rows in a Simple Table

This Specification Flow Task will delete all rows in a Simple Table.

Properties

Property NameDescription
TitleChanges the Title (not the name) of the task.
Simple Table NameThe name of the DriveWorks Project Simple Table that will have its rows removed from.
Delete Header RowTRUE 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 NameExample RuleExample ResultMeaning
Simple Table Name"MaterialCosts"MaterialCostsThis is the name of the Simple Table to Delete all the Rows in.
Delete Header RowTRUETRUEThis will delete all the rows including the headers.

Delete All Except Headers Example

Property NameExample RuleExample ResultMeaning
Simple Table Name"MaterialCosts"MaterialCostsThis is the name of the Simple Table to Delete all the Rows in.
Delete Header RowFALSEFALSEThis 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.