Hi all,

I have an Umbraco 4.5.2 site and I am trying to setup a custom section. I have been running through the Video tutorials but I want to do something slight different than what they suggest. When right clicking on a node an selecting "Delete" rather than completely deleting the record from the table I would rather have it set a value in a status field which would mean it doesn;t display.

I currently have a field in my table called activeStatusID and so far my custom section is only showing entries where this is set to 1, therefore I when I right click on a node an select Delete I would like it to change the value of that field to 2 which would me that it would no longer show in the list. Below is the code that I have got from the videos for deleting an entry (which I cannot get working for some reason). How would I modify this so that instead of deleting the whole row in the database it just changes the value of my activeStatusID field?

 
 
public bool Delete()
{
 
 
Application.SqlHelper.ExecuteNonQuery("delete from Users where id = @id",
 
 
Application.SqlHelper.CreateParameter("@id", ParentID));
 
 
return true;
 
}

Thanks in advance for any help