Rx_
Nothing In Moderation
- Local time
- Today, 06:07
- Joined
- Oct 22, 2009
- Messages
- 2,803
Currently maintaining a database that allows the user to delete the current record. It is a single table in this case.
My preference is never entirely delete things.
I am thinking that making a copy of the table with the name MyTable_Deleted And, right before deleting the current record, copy the record and stick it into MyTable_Deleted.
Was thinking of adding a new field to mark as deleted, but that would lead to all the associated reports to update and re-test.
Just wondering if anyone has some "best ideas" or code to point me to?
Would rather learn from others good deeds. Any good considerations would be greatly appreciated.
My preference is never entirely delete things.
I am thinking that making a copy of the table with the name MyTable_Deleted And, right before deleting the current record, copy the record and stick it into MyTable_Deleted.
Was thinking of adding a new field to mark as deleted, but that would lead to all the associated reports to update and re-test.
Just wondering if anyone has some "best ideas" or code to point me to?
Would rather learn from others good deeds. Any good considerations would be greatly appreciated.