Deprecated
This function is deprecated, and we recommend using the DB:Delete() function from Database API.
Deletes one or more records from the database.
Syntax
Delete()
Arguments
No arguments.
Return value
No return value.
Example 1
Delete all records where the ID is '32':
dynamic tblCars3 = GlobalVars.dal.Table("Carsmake");
tblCars3.Param["id"] = 32;
tblCars3.Delete();
The corresponding SQL query:
Delete from Carsmake where id=32
Example 2
Delete all records where Make is 'Renault' and Model is 'Duster':
dynamic tblCarsModels2 = GlobalVars.dal.Table("Carsmodels");
tblCarsModels2.Param["Make"] = "Renault";
tblCarsModels2.Param["Model"] = "Duster";
tblCarsModels2.Delete();
The corresponding SQL query:
Delete from Carsmodels where Make='Renault' and Model='Duster'
See also:
