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?

Recent Discussions

Windows 11 O.S. - Test Execute not correctly running

How to run failed BDD scenarios automatically?

A floating license among two machines

Related Content

Using Project Scripts and Variables in other projects

Project Variable

Setting Excel filename as project variable