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

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?

TIA,

Mark

PS I posted this earlier though atkin, and it appeared on
http://groups.yahoo.com/group/ib-support/ but not in atkin, so I'm trying
emailing it to ib-support@yahoogroups.com.