Soft-delete record by flagging a value (Flag for delete)

Question:
In our application, when the user deletes a row, we do not want to do a hard-delete, instead we only want to soft-delete the record by flagging a field. Is that possible to accomplish using the phpGrid? 

Solution:
That's possible with trigger for delete. Update the row, then immediate abort the trigger to prevent delete from executing. 

Example:
CREATE TRIGGER orders_soft_delete_trigger BEFORE DELETE ON orders
  FOR EACH ROW BEGIN
    UPDATE orders SET cancel_flag = 1 WHERE order_id = OLD.order_id;
   SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'DELETE canceled'; -- raise MySql generic error manually
  END;


Feedback and Knowledge Base