Forum Discussion

nnguyen_1's avatar
nnguyen_1
Contributor
11 years ago

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

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.Variable...
TCARREON14's avatar
TCARREON14
New Contributor
9 years ago

Does anyone know if this issue has been resolved yet? is there a link to escalate or promote this so that they can include this in a future release? I am running TC11.33.2298 and am getting a type mismatch error when trying to set the variable.

 

here is a snippet of my code:  I am passing over the Variable Name, Variable Type, and the Value. In this case is the path to a CSV file.

 

if varType = "DB Table" then

    Project.Variables.VariableByName(varName) = "{CSV file: " & varValue & "}"

else

    Project.Variables.VariableByName(varName) = varValue

end if