Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overview

Removes all rows on specified table by using column and value as single criteria and returns deleted number of rows.

number $Database.DeleteData(schema: string, table: string, column: string, value: any)

Removes all rows from the specified table by the name or ID number of the Target datastore, using the column and value as the sole criteria, and returns the number of rows deleted.

number $Database.DeleteData(store: string, schema: string, table: string, column: string, value: any)

Arguments

string schema
Name of target schema
string table
Name of target table
string column
Name of column to use as criteria
any value
Value of column to use as criteria
string store
Name or Id number of target data store. This parameter is optional.

Example

Code Block
languagejs
$Database.DeleteData("MySchema", "MyTable", "Id", $Xml.Evaluate('Id'));