Contributions
Re: Updating variable(DB Table) using JScript
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.1.1KViews0likes0CommentsRe: Updating variable(DB Table) using JScript
Marsha_R 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; includingthe 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?1.1KViews0likes2CommentsRe: Updating variable(DB Table) using JScript
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.1.2KViews0likes4CommentsUpdating 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 is pointing at an Excel Worksheet. It is working great but there is a desire to allow others to run the test vial TestExecute. For this approach to work I'd initialize select variables with information obtained via an external file (Excel, CSV, or other). The issue is being to update the variable (DB Table) that is associated with the Data-Driven Loop mentioned above using JScript. Information I've located has allowed me to create a new Variable, read from a variable where the default value is currently defined; just not update/change the path to the Excel Datasource. FWIW: The "intelli-sense" allows me to see some of the methods and properties assocated with this variable but none that I've been able to change the source path/filename. "initialDBTableVar" seemed promising but I wasn't able to see or even change the value that it contains. Thank you1.2KViews0likes6Comments