02-26-2010, 11:15 PM
I had an issue where I was missing, as I was running the same code for a number scripts and I built columns on the fly if they where missing, this maybe or not helpful:
Code:
ColNums=DataTable.GetSheet(dtGlobalSheet).getparametercount
For i=1 to ColNums
ColName=DataTable.GetSheet(dtGlobalSheet).GetParameter(i).Name
Next
If ColName <> Col3 Then
DataTable.GetSheet(dtGlobalSheet).AddParameter "Col3","Test this Col 3"
End If
If ColName <> Col4 Then
DataTable.GetSheet(dtGlobalSheet).AddParameter "Col4","Test this Col 4"
End If
Test1=DataTable("Col3", dtGlobalSheet)
Test2=DataTable("Col4", dtGlobalSheet)
msgbox(Test1)
msgbox(Test2)