You will probably have to make it happen in two stages. First you would set the deletion date field and commit it, then do the delete.
>Hi, all
>I have a field designed to keep the deletion date of the record. And the table is updated through a view. Each time I delete a record, the deletion date is replaced.
>However, I found that the deletion date is only changed in the view, and it is not updated to the table. The deletion status has been triggered, though. The deletion date field is set to be updatable in view designer, that is for sure.
>Any idea about this?
>TIA
Cy Welch
Senior Programmer/Analyst
MetSYS Inc