Hi friend
I have query regarding QTP datatable.
I want to insert data in datatable during runtime.

suppose i wrote

datatble.value(1) = "Test data"

so when i run the script it says column(1) doesn't exist.

Then i write something in column A1 manualy and run the
script again.

Now it works fine.

Pls clarify how i can put value in blank cell of datatable.

Answers were Sorted based on User's Feedback



Hi friend I have query regarding QTP datatable. I want to insert data in datatable during runtime..

Answer / arun singh

first of all u have to change the column name.
i.e., double click on A and run the program.

got it.

Is This Answer Correct ?    10 Yes 3 No

Hi friend I have query regarding QTP datatable. I want to insert data in datatable during runtime..

Answer / rajaputra

Hi,
USE THIS,

datatable.getsheet(1).addparameter"Test",""
datatable(1,1)="Test Data"

Run and see the runtime datatable

Is This Answer Correct ?    7 Yes 2 No

Hi friend I have query regarding QTP datatable. I want to insert data in datatable during runtime..

Answer / medena

DataTable.GetSheet(1).AddParameter "Test",""
datatable(3,1)="Data Test1"
DataTable.SetNextRow
DataTable(3,1)="Data Test2"

Is This Answer Correct ?    7 Yes 2 No

Hi friend I have query regarding QTP datatable. I want to insert data in datatable during runtime..

Answer / medena

I use this to fill the column with some values

Is This Answer Correct ?    4 Yes 1 No

Hi friend I have query regarding QTP datatable. I want to insert data in datatable during runtime..

Answer / sameer

=======
DataTable(ParameterID [, SheetID]) =NewValue This is what
is specified in data table help.

That means you should use:

DataTable.SetCurrentRow(1)
DataTable(1,dtGlobalSheet) = "Test" ...If you are to insert
data in the first row and first column of global sheet.

I am using the same...n it's working..

Is This Answer Correct ?    4 Yes 1 No

Hi friend I have query regarding QTP datatable. I want to insert data in datatable during runtime..

Answer / prashanth

Hi Friend,

Try this...

In the Datatable, in the first row, first column u can
find "A". DoubleClick on "A" and give any name like..."Test"

Now, in the Active Screen...

DataTable.Value("Test", Global)="Test data"

'Now if you want to use the value present in the datable,
in the script...

K=DataTable.Value("Test", Global)

Now, the value "Test Data" is stored in the variable "K"


Thanks,
Prashanth
prashanth.vikey@gmail.com

Is This Answer Correct ?    4 Yes 1 No

Hi friend I have query regarding QTP datatable. I want to insert data in datatable during runtime..

Answer / mercy

try putting datatable.value(2.1)="Test data". I have the
same prob...trying to resolve this the same way. will let u
know once done.

Is This Answer Correct ?    3 Yes 2 No

Hi friend I have query regarding QTP datatable. I want to insert data in datatable during runtime..

Answer / rajasekaran

By using Ouput Values concept we can insert in datatable
during runtime. but we can see the value only in Test
result,select runtime table in left side of he test results

Is This Answer Correct ?    2 Yes 2 No

Hi friend I have query regarding QTP datatable. I want to insert data in datatable during runtime..

Answer / sekhar

Hi friends,when we need to insert the values in to datatable
we can write script like

datatable("column name",sheetid)=value

Then the given value will be stored in desired sheet and
given column,

Is This Answer Correct ?    0 Yes 0 No

Hi friend I have query regarding QTP datatable. I want to insert data in datatable during runtime..

Answer / siraj

Before inserting value in the cell, first we need to create
column by using "addparameter" then we can insert value in
that column.

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More QTP Interview Questions

what are the Common Problems in S/w development process

1 Answers  


How to find Operating system information using QTP script?

0 Answers  


How do u write a regular expression for date (dd/mm/yyyy) field?

10 Answers  


In descriptive programming how we know the properties of the objects, if application is not developed and the prototype of the application is also not developed.

1 Answers  


Hi guys, Please suggest some thing these points are correct???, Is UFT 12 and QTP outdated ??? and also VBscript is also deleted/Removed from QTP ???? Javascript is added latest and tool name is called JFT ??? From this year ??

2 Answers  


Hello Everybody, please tell me how to use accessibility checkpoint and XML checkpoint by giving any practical example of it.please provide me the steps to perform that and also pls provide the code too. Thanks in advance, Gaytri

1 Answers  


is the institute MindQ laid by Mr.Nageswar rao.. heard alot about Nageswar rao...can you briefly let me know about the Nageswar rao inst. and MinQ...THANX IN ADVANCE

44 Answers   InterGraph,


How to make arguments optional in a function?

1 Answers   Crea,


How to supress warnings from the "Test results page"?

3 Answers   Crea,


what is impact analysis on regression testing?

0 Answers   L&T,


Hi All , How can we decicde for pariticular frame(DataDriven or Keword Driven)in Project? Thanks Balaji

0 Answers  


Could any one suggest web site links to learning VB Script for QTP purpose??

3 Answers  


Categories