Column Names in DataTable within QTP

[vijayendra.shukla]

Hi,

I was trying use the below code to set values in DataTable

Code:

DataTable("A", Action1") = 2010

But i am getting error "The set DataTable.Value operation failed. The <A> column does not exist."

When i renamed this column it worked.
Is it the displayed column names in the DataTable are not really the column names like in excel sheet??? Because when i renamed this column to "A" (which was already getting displayed in DataTable) it worked.

[Saket]

Datatable columns can not be said as columns as we say in the excel.
In QTP we say it - 'Parameter'
Datatable will set a value in any of the column that you see there until it is specified as parameter
refer Parameterization in QTP help for more details

[Jackomcnabb]

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)

[perplexed]

thanks jackomcnabb. It definately helped.