db4breakfast (3/21/2013)
To be clear, we don't allow users to delete any record in our application. However there's a function for users to flag a record as error. Instead of cascade delete, the application just flag the record as "error" in the parent table. All data are still there.
Well, we do allow it .. depends on business scenarios ..
In our case, it just marks a record for delete followed up by a workflow , background, process that deletes the records and it's associations ..
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm: