Delete DataTableRows
Use this command to delete rows in a DataTable object. You can delete all rows in or only the rows that meet a specific condition.
By deleting all rows, you can use this to reset the DataTable object before you use the Download (for DataTables) command to refresh the data in the DataTable. You can also use this command, followed by the Upload (for DataTables) command, to clear out the data in the App table that was included in the DataTable object.
To delete the DataTable object, see Delete DataTable.
Syntax
DELETE DATATABLEROWS FROM DataTableName [WHERE "[ConditionalColumn1]Operator 'ConditionValue1' [AND|OR [ConditionalColumn2] Operator'ConditionValue2]"]
where:
- DataTableName is the name of the DataTable object in which to delete rows.
- WHERE deletes only the rows that meet the specified condition. If you do not specify a WHERE clause, all rows in the DataTable are deleted.
- ConditionalColumn1 is the column that must contain a specified value for the row in order for the row to be deleted. If a column name contains spaces, you must enclose it in square brackets. For example [Employee Type]. You cannot specify a userlist column as a ConditionalColumn.
- Operator is the relational operator and can be one of the following:
Value Description EQ or ==
Equal to.
GE or >=
Greater than or equal to.
GT or >
Greater than.
LE or <=
Less than or equal to.
LT or <
Less than.
NE or !=
Not equal to.
- ConditionValue1 is the value that ConditionalColumn1 must contain in order for the row to be deleted. Values can be numbers or strings, or, in the case of boolean columns, 1 for TRUE and 0 for FALSE. You must enclose string values in single quotes. For example, 'contract'.
Note: You can specify two conditions separated by one And or Or clause.
Syntax example
DELETE DATATABLEROWS FROM ExecutiveSalaries
Syntax example
DELETE DATATABLEROWS FROM ExecutiveSalaries WHERE "[Office Location]= 'Sunnydale' OR [Office Location] ='Smallville'"
See also