Deletes records from a database. The second parameter must be specified for the method to be executed successfully.
Syntax
DB_Delete table,values
' or
DB_Delete table,where
Arguments
table
the table from which the data is deleted.
values
an array with values that define the condition for the delete query.
where
the condition for the query; if unspecified, no action will be done.
Return value
No return value.
Example
' delete from Cars where id=50
Dim data
Set data = CreateDictionary()
data("id")=50
DB_Delete "Cars",data
Alternative syntax:
// delete from Cars where id=50
DB_Delete "Cars", "id=50"
See also: