Hi,

I'm looking for feedback, and some guidance from those more familiar with WORM then myself, on the best way to do logical deletes with WORM.

For example, I want to set an IsDeleted field to true instead of calling DELETE FROM on the record. Obviously all the SELECT queries on that table need to be modified to include a IsDeleted = 0 where clause.

I asked this question a couple of months ago, but didn't get much of a reply. I've had more of a chance to look through the source code of WORM, and I've had some ideas.

I could write my own adapter, but that looks (a) not re-usable, (b) the wrong place to do it, and (c) prone to mistakes.

I can just intercept the SQL on the way to the DB, and modifiy it as required, but that's a bit nasty, too.

Paul, do you have any suggestions as to how you would approach this? This is a feature I'd be happy to work on, and contribute patches for, so I'd like to fit in with your overall plans for the direction of WORM if possible.

Cheers
Matt