Local DB Delete

The Local DB Delete action deletes rows from a local database table. An optional Where clause can be used.

Parameter descriptions

Parameter	Description
Table	The name of the local database table for the delete operation. The table name will be available from a drop-down list.
Where	A Where clause can be used to restrict the rows to be deleted. Both constants and substitution variables can be used in the Where clause. To construct a Where clause, use an operator (=, !=, >, >=, <, <=, like, is null, is not null ) to relate the column to either a constant or a substitution variable. Each of these operators can be combined with other operators using an And or Or statement. To use a substitution variable, insert $(x) where x is a variable that will be associated to a variable on the Input tab (see the Input tab below). Note: For columns of type TEXT, the constant or substitution variable must be enclosed in double quotes. For example: C01 = "JohnDoe" The constant is enclosed in double quotes. C01 = "$(test)" The substitution variable is enclosed in double quotes. The variable (test in this example) will be added to the Input tab and can then be mapped to a STRING variable (or a constant). The Where clause builder, accessed by selecting the icon , can be used to assist in building the Where clause. For more information on the Where clause builder, see Local DB Select

Parameter

Description

Table

The name of the local database table for the delete operation. The table name will be available from a drop-down list.

Where

A Where clause can be used to restrict the rows to be deleted.
Both constants and substitution variables can be used in the Where clause.
To construct a Where clause, use an operator (=, !=, >, >=, <, <=, like, is null, is not null ) to relate the column to either a constant or a substitution variable.
Each of these operators can be combined with other operators using an And or Or statement.
To use a substitution variable, insert $(x) where x is a variable that will be associated to a variable on the Input tab (see the Input tab below).

Note: For columns of type TEXT, the constant or substitution variable must be enclosed in double quotes. For example:

C01 = "JohnDoe"
The constant is enclosed in double quotes.
C01 = "$(test)"
The substitution variable is enclosed in double quotes. The variable (test in this example) will be added to the Input tab and can then be mapped to a STRING variable (or a constant).

The Where clause builder, accessed by selecting the icon , can be used to assist in building the Where clause.
For more information on the Where clause builder, see Local DB Select

Input tab

Optional. The Input tab will only appear when a Where clause is specified and the Where clause contains a logical variable (for example, $(Variablename)).

There will be as many rows on the Input tab as there are logical variables in the Where clause.

Parameter	Description
Logical Variables from the Where clause	The variable whose value is to be substituted in the Where clause clause logical variable. This variable can be any type of variable in the system.

Output tab

Parameter	Description
Rows Deleted	The actual number of rows deleted from the table.
Error Message	Optional. Used to provide information if the delete fails.

Local DB Delete

Related topics