Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » UltraLite - .NET Programming » UltraLite.NET application development » Data creation and modification using SQL statements » Data modification using INSERT, UPDATE, and DELETE

 

Deleting a row in a table

Placeholders for parameters in SQL statements are indicated by the ? character. For any INSERT, UPDATE, or DELETE, each ? is referenced according to its ordinal position in the command's parameters collection. For example, the first ? is referred to as 0, and the second as 1.

Prérequis

There are no prerequisites for this task.

 Task
  1. Declare a ULCommand.

    ULCommand cmd;
  2. Assign a statement to the ULCommand object.

    cmd = conn.CreateCommand();
    cmd.CommandText = "DELETE FROM MyTable WHERE MyColumn = ?";
  3. Assign input parameter values for the statement.

    String deleteValue;
    
    cmd.Parameters.Clear();
    
    // assign value
    cmd.Parameters.Add("", deleteValue);
  4. Execute the statement.

    int rowsDeleted = cmd.ExecuteNonQuery();
  5. If you are using explicit transactions, commit the change.

    myTransaction.Commit();

Résultat

Row entries from MyTable are deleted where the MyColumn value in the table is an empty string.