cauline
8 years agoContributor
Is there a way to set a DB Table variable programmatically in JavaScript?
I am trying to programmatically setup a DB Table variable in JavaScript. Is there a way to do this, or do I have to go through the Wizard? Thx!
- 8 years ago
Research the DDT object and associated "driver" methods. Basically, the variable type of DB Table that you find in Project, Project Suite, and Keyword Test variables are a UI way of creating this DDT object type.
So, for example, if you want to have a DB Table of data in an excel spreadsheet and be able to, on the fly, create that variable, you COULD do...
function getExcelData(excelFilePath, sheetName) { return DDT.ExcelDriver(excelFilePath, sheetName, true); }
Running that function with the necessary data will create such a driveable object.
Then, TECHNICALLY what you could do is create a variable that has a type "Object" and assign the result of that function to it. Like so.function getExcelData(excelFilePath, sheetName) { return DDT.ExcelDriver(excelFilePath, sheetName, true); } function foo3() { Project.Variables.dbObject = getExcelData('C:\\Source\\Sandbox\\JavaScriptProject\\Script\\Book1.xlsx', 'DataSheet1'); while (!Project.Variables.dbObject.EOF()){ Log.Message(Project.Variables.dbObject.Value('Value1')); Log.Message(Project.Variables.dbObject.Value('Value2')); Project.Variables.dbObject.Next(); } DDT.CloseDriver(Project.Variables.dbObject.Name); }