Re: Marking records as deleted rather than physically deleting them
Rachael,
I would absolutely augment Procedure Delete_Main_File for this.
Code:
Procedure Delete_Main_File
Move 'Y' to ....
Move (CurrentDateTime()) to ....
SaveRecord <table>
End_Procedure
The point being that you want all the normal delete functionality to be triggered. So that is, Procedures Deleting and Backout. I doubt you'd want Update triggered, hence I'd be nervous about augmenting Procedure Request_Delete to call Request_Save instead. You might have logic within Update and Backout that adjusts totals, and these need to be handled as if the record were indeed deleted.
"My wife thinks I over-analyse our marriage, which, to be frank completely contradicts the findings of my report." - @MooseAllain