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(); }