Marking a record as deleted

[bthumber]

How do you mark a record as deleted in a database so that a user cannot see
the record? Then later unmark the record.

thanks

 

[Kerry Moorman]

bthumber,

I don't know of a database that supports such a feature.

You would need to implement that yourself and only allow the user to
indirectly view the data in the table via a stored procedure that would not
display the "deleted" rows.

Kerry Moorman

 

[ACook]

You could create a 'deleted' column with a datatype of bit and filter on
that when you select.

 

[Cowboy \(Gregory A. Beamer\)]

Add a boolean (bit) field IsDeleted and respect it when you do your selects.

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Subscribe to my blog
http://feeds.feedburner.com/GregoryBeamer#

or just read it:
http://feeds.feedburner.com/GregoryBeamer

********************************************
| Think outside the box! |
********************************************