Updating variable(DB Table) using JScript
Sorry if this has been answered previouly but a search of the Community and Google didn't quite turn up what I need to move forward.
I have a KeywordTest that contains a Data-Driven Loop that i...
Forum Discussion
Thank you for your response and coincidently I've considered it as an alternative approach. In this instance, I'm using TestComplete as a utility to enter data into an application as opposed to actual application development/testing. Loading of data will happen on a regular bases so I was looking for flexiblity for one running TestExcecute to update a "control file" prior to executing it. Meaing, have them update a control file with the new file name, target instance of the application, and etc.
I figured that since I can access the DB TABLE variable via JScript there's likely a means to update the Default Value as I would do manually within TestComplete.
FWIW: If I can't update the variable dynamically then I'll likely do something similar to what you're proposing.
Thanks again for responding.
You could do that with your control file but I would update everything before you run the DDT loop so you still don't need to update the part of the test that has all the references to the spreadsheet, etc. Update variables with your control file and then run the loop.
Agreed and that is the intent. The control file would be read first, tested for valid values, and assign the values to select variables. My existing script would run; including the DDL.
Unfortunately, the DDL is the only object that I'm working with that uses a variable with a DB TABLE variable type which raised this question. How does one update this variable dynamically?
Technically you don't. There's a possible workaround though:
I've gone through the reference web page it isn't allowing or showing how one assigns the path/filename.
Meaning, it indicates to create a new variable with the type of "DB Table" which I've been able to do. Unfortunately, I can't see or know how to go about setting the "initialDBTableVar". What I end up with is the new variable but it doesn't have the "Default Value" populated.
So, is there then a method or assignment that I can do to "initialDBTableVar" to provide path/filename? (worksheet name isn't likely to change but I do see it as part of the manually created variable.)
I do appreciate your help as I just seem to be missing that last step to change a object's property.
