XenoGuard 4.0 Documentation

Delete Table

ActionStep Reference » Windows » Database » Delete Table

The ActionStep Delete Table removes a record from a database table based on specified conditions in the filter.

[+] How to add the Delete Table ActionStep to the ActionScript:

[-] Hide

Open the Windows node in the Workspace Explorer.
Open the Database node, select the Delete Table ActionStep.

Parameters:

The ActionStep has the following input parameters:

name	Description
Connection String	The string used to authenticate and connect to the database. Allowed Context Scopes [Fixed, Local, Global] Allowed Context Type [Variable, Parameter, Enum]
Table	The name of the table where the record is to be deleted. Allowed Context Scope [Fixed, Local, Global] Allowed Context Type [Variable, Parameter, Enum]
Filters	The filter to be used in creating the WHERE clause. Parameters for the Filter sub-branch: Logical Operator - identifies the relationship between two or more filters Field - the column or field name in the table Operator - the operation to be used to create the WHERE clause Value - the value to be used to create the WHERE clause Allowed Context Scope [Fixed, Local, Global] Allowed Context Type [Variable, Parameter, Enum]

name

Description

Connection String

The string used to authenticate and connect to the database.

Allowed Context Scopes [Fixed, Local, Global]
Allowed Context Type [Variable, Parameter, Enum]

Table

The name of the table where the record is to be deleted.

Allowed Context Scope [Fixed, Local, Global]
Allowed Context Type [Variable, Parameter, Enum]

Filters

The filter to be used in creating the WHERE clause.

Parameters for the Filter sub-branch:

Logical Operator - identifies the relationship between two or more filters
Field - the column or field name in the table
Operator - the operation to be used to create the WHERE clause
Value - the value to be used to create the WHERE clause

Allowed Context Scope [Fixed, Local, Global]
Allowed Context Type [Variable, Parameter, Enum]

Operator Parameter Descriptions in the Filter Sub-branch:

Operator	Description
LIKE	Search for a text or a word in a line.
=	Search for a text that is equal to the target value.
!=	Search for a text that is not equal to the target value.
<	Check if the number is less than the target number value.
>	Check if the number is greater than the target number value.
<=	Check if the number is less than or equal to the target number value.
>=	Check if the number is greater than or equal to the target number value.

	The "Provider" and "Data Source" must be included in the string to ensure an established connection.

Results:

The ActionStep returns the following results:

name	description
Success	The returned boolean result of the operation. Allowed Context Scope [Fixed, Local, Global] Allowed Context Type [Variable, Parameter]

Example 1 (Delete a specific record from the database table):

This example creates two local variables, TableName and AccountName with Text as data type. A connection to the database is then established and asks the user if a record will be deleted. Once confirmed, the value of the TableName variable is set as table parameter and the AccountName variable as the filter value. If the record was successfully deleted from the database table, a notice is then displayed in Message Box.

See other Database operations:

Create Connection
Create Table
Select Table
Insert Table
Update Table