How do I set project variable (DB table type) by scripting?

Question

In regards to the instruction at http://support.smartbear.com/viewarticle/28726, I should be able to set value for project variables by scripting. In VBScript, looks like this:

Project.Variables.AddVariable "MyVar", "String"

Project.Variables.MyVar = "Hello, world!"

My question is how do I set a DB table variable (particularly an instance of Excel file) by scripting? Is it possible to do something like this?

ProjectSuite.Variables.AddVariable "Test", "DB Table"

ProjectSuite.Variables.Test.WorkBook = "C:\test.xlsx"

ProjectSuite.Variables.Test.WorkSheet = "TestDataSheet"

I tried but TestComplete throws run-time error all the time (no syntax error though). Any advice pls?

P/S: I saw some code snippets to add column by column, value by value at http://support.smartbear.com/viewarticle/33254/. However, I think it's too much work, especially my excel file is created on the fly with hundreds of columns and rows, I cannot specify them all one by one.

anik_cadieux · Answer

I sent a support ticket in november 2013 (TestComplete 9) and here is their answer:

De : SmartBear QA Support [mailto:QA-Support@SmartBear.com]

Envoyé : 8 novembre 2013 00:39

À : Cadieux, Anik

Objet : RE: [Issue# M0118168] Web Submission - How do I set project variable (DB table type) by scripting?

Hello,

Currently, assigning a source cannot be done in script. We have registered this request in our database. Thank you.

You need to initialize a DB Table type variable in the Edit DB Table Variable Value wizard:

http://support.smartbear.com/viewarticle/33544/

Best regards,

Vince

I doubt this behavior has changed in TC 10.

nnguyen_1 · Answer

I found the solution, it required manually manipulating process, but I can get rid of the constants in project suite.

Pseudo code:

'Create an Excel.Application object

Set objExcel = CreateObject("Excel.Application")

'Open the excel file

objExcel.Workbooks.Open(strExcelFilePath)

'Check if the worksheet exists

'If yes, activate it, if no, create and activate it

'Move to the last row to append data (intLastRow)

'Loop and Append data to Cells (intLastRow, column)

'Save active worksheet and close it

'Quit excel and destroy objExcel

Note: CreateObject("Excel.Application") may return errors without reason in VBScript since VBScript doesn't support Early Binding (Read more here: http://msdn.microsoft.com/en-us/library/0tcf61s1.aspx). I handled it by using On Error Resume Next.

anik_cadieux · Answer

I am looking for the exact same thing, Viper.If you ever find a way to set DB Table variable workbook and worksheet &nbsp;directly from TestComplete's &nbsp;functions in script, please let me know !

temich6059 · Answer

I too am having the same sort of problem. &nbsp;I've looked all over the Internet, but have not found any solution. &nbsp;Would anyone here have an answer?

oleg_sigalov · Answer

Hey guys,&nbsp;Is there any solution?

Forum Discussion

How do I set project variable (DB table type) by scripting?

7 Replies

Related Content

Using Project Scripts and Variables in other projects

Setting Excel filename as project variable

Project Variable

Use of project persistent variables as common variable across multiple test scripts.

Creating array with Project variable

Recent Discussions

Multiple execution of a test plan with different values from an Excel table

Searching for mapped object took too much time msg

mht files are by default opening in Edge browser and its blank

Azure Devops Integration supports Testcomplete Base Fixed Dektop Module License

Devops integration support