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 is repository parameters in QTP?how will we define that????what is unmapped & mapped repository parameters????????

1 Answers  


Any body have QTP 9.5 licence key. please provide me at madhukar_dec30@yahoo.co.in

0 Answers  


when there is a task that gets repeated in multiple scripts what do you do in QTP?

2 Answers   Ordain Solutions,


we have one text box and one list box(list box appear in same page or another page) what ever the text enter in text box that must be displyed in list box as first one. for example if we enter 10 in text box that is the 1st item in list box . after that we enter 11 then 11 is the 1st item and 10 is 2nd item. the maximum limit of list box is 10 items. if we enter 11th item the 10th item is deleted and llth one is add as 1st one and 9th one goes to 10th position part2:maore than the answer for this question i want the the reason why testers go for this kind of risk.what is the use of we testers having these kind of attempts.is that not the problem with the developer .pls answer .real time users of tools.in which way these solutions help to test with r without affecting the developed souce code.

3 Answers  


How QTP support all types of applications (platforms)?

0 Answers  






can u Give Procedure to Handle Pop Window & write Code for that

2 Answers   CTS,


I want to know what are QTP functons and what are VB script functions. What is the difference between them.When we have to use these functions.

0 Answers  


How do function returns a value?How can we pass one function value to other function as input

3 Answers  


Please let know the scripts for counting number of repeated letters in the word. Note repeated letter should not be count agian. Ex: If "Hello" is my word... l is coming twice.. it should count once and print... secong 'l' should not count again..

1 Answers  


When a requirement is given to u to automate , What is ur basic approach ?

4 Answers  


How is test case write?

0 Answers  


HOW TO DO THE BATCH TESTING USING QTP?

2 Answers   Ordain Solutions,


Categories