How to put value in Table (Variables)
Hi, I wanted to know if it's possible to put values in a Table (in the Variables Object) with a script. I don't want to have to work with the interface, it will be too long for me. Is it...
Forum Discussion
Is it possible to retrieve a value from the table as can be done in VBScript with:
set dict = CreateObject("Scripting.Dictionary")
dict.add "Italy", "Rome"
dict.add "Germany", "Berlin"
msgbox dict.item("Italy") -> returns "Rome"
e.g.
Dim t
If Not Project.Variables.VariableExists("MyTable") Then
Call Project.Variables.AddVariable("MyTable", "Table")
End If
Set t = Project.Variables.VariableByName("MyTable")
Call t.AddColumn("Name")
Call t.AddColumn("Age")
Call t.AddColumn("City")
t.RowCount = 2
t.Name(0) = "John Smith"
t.Age(0) = 24
t.City(0) = "Seattle"
t.Item("Name", 1) = "Bob Feather"
t.Item("Age", 1) = 59
t.Item("City", 1) = "Milltown"
msgbox t.item("City", "Name" = "Bob Feather") <- I want the City where the Name is Bob Feather
How to do this ?
Wow. it's realy-realy very interesting.
