I sometimes need to make some other update operation within OnUpdateRecord-event than the user made in the dataset - typically: user edited a dataset and cleared a value and i need to delete the record, not only modify it to NULL.

I programmed a subclass of TMSQuery full of useful code and among others I also included following method: