XenoGuard Documentation

Delete Table

Actions » Windows » Database » Delete Table 

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


[-] Hide
  1. Open the Windows node in the Workspace Explorer.
  2. Open the Database node, select the Delete Table action.

Parameters:

The action 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]

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.

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

Results:

The action 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