12-23-2008, 02:08 AM
12-23-2008, 09:14 AM
Yes. Use method to get the total no of columns. Loop through all the columns to check for the existence. If it is not found add a parameter (column) using method.
Code:
GetParameterCountCode:
AddParameter12-23-2008, 07:47 PM
[quote=Jackomcnabb]
Thanks a lot.
I had a datasheet with two Columns (Col1 & Col2) and I need to verify that if there was not a Col3 to add to to my script so when it is called later the call would not fail
Thanks a lot.
I had a datasheet with two Columns (Col1 & Col2) and I need to verify that if there was not a Col3 to add to to my script so when it is called later the call would not fail
Code:
a=DataTable.GetSheet(dtGlobalSheet).getparametercount
For i=1 to a
b=DataTable.GetSheet(dtGlobalSheet).GetParameter(i).Name
Next
If b <> Col3 Then
DataTable.GetSheet(dtGlobalSheet).AddParameter "Col3","Test this "
End If
Test1=DataTable("Col3", dtGlobalSheet)
msgbox(Test1)