Please enable JavaScript to view this site.

Navigation: Advanced topics > Programming topics > Database API > Methods

Database API: Delete

Scroll Prev Next More

 

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:

Database API: Insert()

Database API: Update()

Database API: Select()

About Database API