Do not use the CDelete class directly. Use the preallocated WIDatabase.Delete variable instead.

Functions to Delete records from tables.

Namespace: Wiker.WIDatabase
Assembly: 

Syntax

C#
public class CDelete : CConditionCommon
Visual Basic
Public Class CDelete _
	Inherits CConditionCommon
Visual C++
public ref class CDelete : public CConditionCommon

Examples

CopyC#
WIDatabase WIDB;
CDatabaseInfo DBInfo;

/* Create CDatabaseInfo object and populate with database login info */
DBInfo = new CDatabaseInfo();
DBInfo.DatabaseType = eDatabaseType.SQL;
DBInfo.Location     = "SqlServer";
DBInfo.DBName       = "TestDatabase";
DBInfo.Username     = "LoginName";
DBInfo.Password     = "LoginPassword";

/* Create new instance of WIDatabase */
WIDB = new WIDatabase(DBInfo);

/* Set table name to delete from */
WIDB.Delete.Table("tblTableName");

/* Set Condition (WHERE) cause */
WIDB.Delete.Condition("LastName", eOperator.EndsWith, "ton");

/* Deletes all records in table 'tblTableName' where column 'LastName' ends with 'ton' */
if (!WIDB.Delete.Execute())
   {
   MessageBox.Show(string.Format("Failed To Delete records\n{0} - {1}", 
                   WIDB.LastError.ToString(), WIDB.LastErrorMessage));
   }

WIDB.Close();

Inheritance Hierarchy

System..::..Object
  Wiker.WIDatabase..::..CConditionCommon
    Wiker.WIDatabase..::..CDelete

See Also