Subject How to test sequence and roll back?
Author Mark Patterson

I want to test a sequence of scripts, adding fields, giving them values and so,
and then roll back, so that I can test the scripts until they all work, and then
use them in earnest on the production database. I do
Transcation.StartTransaction, call all the scritps and then Transcation.Rollback.

But at first I was getting errors trying to put values into the new field. Then
I put CommitRetaining, but that means that the field is still there after the
rollback. What's the trick?



PS I posted this earlier though atkin, and it appeared on but not in atkin, so I'm trying
emailing it to