Subject | How to test a sequence then rollback? |
---|---|
Author | Mark Patterson |
Post date | 2002-08-28T04:06:46Z |
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
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