Subject | How to test sequence and roll back? |
---|---|
Author | Mark Patterson |
Post date | 2002-08-28T05:17:54Z |
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.
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.