> Any ideas about this?

...

>>So here it is. Why not create a sort of "undo-after-commit"
>>feature, whereby old versions of a record could be kept
>>indefinitely, and if necessary, restored of viewed?

...

Sounds like an audittrail to me :-)

I do this using triggers to log tables. There is a product
called IB LogManager, I have not used it but believe it is a
product that automates the configuration of audit/log tables
for you. See: http://www.upscene.com/

--
Geoff Worboys
Telesis Computing