how can we retrieve ten rows from the data table using
loop concept?
Answers were Sorted based on User's Feedback
Answer / sreeprasad
Assume "Column1" is my column name in the Global Data
table, then use this code:
for i=1 to 10
datatable.setcurrentrow(i)
returnvalue=datatable.value("Column1","Global")
msgbox(returnvalue)
next
| Is This Answer Correct ? | 1 Yes | 1 No |
Hi Sreeprasad..this will take 10 rows..but the loop will
execute no.of times that how many rows in datatable.
If u r using 9.0 or above version..
set app = createobject("quicktest.application")
set qtest = app.test
qtest.settings.run.startiteration = 10
qtest.settings.run.enditeration = 20
this script will execute only 10 rows starts from 10 th row
and ends with 20 th row.
If any queries..
nanda.dreddy@gmail.com
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / baba
hello nanda, sreeprasad answer is correct... if you worked
on datatable. you will change settings in test settings in
run tab as run on one iteration only.
then it will take from 1 row to 10 only once.
but he forgot this
Function rcnt(rowcount)
if (rowcount>10) then
for i=1 to 10 step 1
val=datatable.value("column1",dtGlobalSheet)
print "Value of"& i &"row is : "&val
datatable.setnextrow
Next
else
msgbox "rowcount is less than 10, requiement is not _
satisfied"
End If
End Function
rows=datatable.getsheet("Global").getrowcount
msgbox rows
row_cnt=rcnt(rows)
print row_cnt
| Is This Answer Correct ? | 0 Yes | 1 No |
How do function returns a value?How can we pass one function value to other function as input
3 differences between QTP & Winrunner?
who is developed QTP ? is it from Mecury or HP
How to handle Dynamic Arrays?
Write the vb script for the lowest and highest values of an array?
What are the differences between qtp and winrunner?
write script for , launching fr window,login and create 5 elements array and store 5 order numbers inthat array? and open order by using order no.s in array and find out maximum tickets booked by which order?
WHAT IS SMATR IDENTIFICATION? plz EXPLAIN BRIEFLY? IS IT POSSIBLE in QTP? HOW AND WHEn THE SITUATION U R USING EXPLAIN WITH EXAMPLE?
How to export data present in Datatable to an ".xls" file?
How to record & run on Japanese language application using english version of QTP ???
What is system testing and what are the different types of tests you perform in system testing?
In a web application , there is a table of rows and coloums , i want to pickup the 1st row and 3rd coloums name (not data)how can any one explain