13 years ago
data-driven-loop on different db-connections
Hi,
I have a data-driven-loop using a DB-Table Variable in my project. The problem is that the connection string for the DB may vary. For example if I want to test the bugfix-db instead of the development-db.
Is it possible to change the DB-Table Variable in a script so that I first run the script setting the DB-Table Variable and then use the data-driven-loop?
I just figured out how I can handle the whole task using a script... something like this:
Sub TestProc
set Kampagnen = ADO.CreateADOTable
Kampagnen.ConnectionString = "connection_string..."
Kampagnen.TableName = "table_name..."
Kampagnen.Open
Kampagnen.First
For i = 0 To 9
' Do everything what should be done in the designer
Kampagnen.Next
Next
Kampagnen.Close
End Sub
...but thats not excatly what I want to do because this way I can't benefit from the "Test-Steps-Designer View".
Benjamin
I have a data-driven-loop using a DB-Table Variable in my project. The problem is that the connection string for the DB may vary. For example if I want to test the bugfix-db instead of the development-db.
Is it possible to change the DB-Table Variable in a script so that I first run the script setting the DB-Table Variable and then use the data-driven-loop?
I just figured out how I can handle the whole task using a script... something like this:
Sub TestProc
set Kampagnen = ADO.CreateADOTable
Kampagnen.ConnectionString = "connection_string..."
Kampagnen.TableName = "table_name..."
Kampagnen.Open
Kampagnen.First
For i = 0 To 9
' Do everything what should be done in the designer
Kampagnen.Next
Next
Kampagnen.Close
End Sub
...but thats not excatly what I want to do because this way I can't benefit from the "Test-Steps-Designer View".
Benjamin