B bthumber Aug 16, 2008 #1 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
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
K Kerry Moorman Aug 17, 2008 #2 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
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
A ACook Aug 17, 2008 #3 You could create a 'deleted' column with a datatype of bit and filter on that when you select.
C Cowboy \(Gregory A. Beamer\) Aug 18, 2008 #4 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! | ********************************************
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! | ********************************************