TOPIC: Deleted Items

public object DoWork()
{
  if (InValues.Length != 2)
  {
    throw new Exception("2 input parameter expected");
  }

  // don't execute SQL delete statements in test mode!
  if (AdapterWrite.OnlyTest == false)
  {
    // get field value "ID" = first input parameter
    int iID = (int)InValues[0].GetInt();

    // get field value "DeleteFlag" = second input parameter
    bool bDelete = (bool)InValues[1].GetBoolean();
   
    if (bDelete)
    {
      string sql1 = "delete from Your_Table_on_READ where id = " + iID.ToString("0");
      string sql2 = "delete from Your_Table_on_WRITE where id = " + iID.ToString("0");

      // Execute the delete SQL statement on the READ database
      AdapterRead.Execute(sql1);

      // Execute the delete SQL statement on the WRITE database
      AdapterWrite.Execute(sql2);
    }
  }
  
  // just returning the first input parameter = field ID
  return InValues[0].GetValue();
}