If i entered 2 columns and 4 rows inputs in DDT Like Mango
fruit, Banana Fruit, Brinjal Veget, Carrot Veget.. . My Q
is How to get the 2nd column value for corresponding 1
column input in 3rd row ie, ( i need to get "veget" in
messge box @ run time
Answers were Sorted based on User's Feedback
Answer / satya
strCnt=DataTable.getRowsCount
For i=1 to strCnt
datatable.SetCurrentRow(i)
x=datatable.Value("A")
datatable("c")=x
Next
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / ratna
datatable.setcurrentrow(3)
x=datatable.value(2,1)
'datatable.value(2,1) where 2 is column name and 1 is sheet
no. ie., 1 is for global sheet
msgbox x
'output is veget
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / saff
i= inputbox "enter ur string" # say brinjal
r=datatable.getrowcount #get row count
for i=1 to r #loop till the end of the row
datatable.setcurrentrow(i)
aa=datatable.(a ,dtglobalsheet) # column 1 value into aa
if instr(aa,i,1)=1 #compare the strings
bb=datatable(b,dtglobalsheet)
msgbox bb
exit
else
i=i+1
next
| Is This Answer Correct ? | 0 Yes | 1 No |
How can i test an application like Google Earth.In my application data will be fetched from a oracle database based upon which graphs are generated..so these all are dynamic..how can i use qtp here..alongwith that how can i test the map generated by a satellite just like google earth..
hi in real time who will execute the qtp test scripts? my faculty said, in a companty automation testers are written the test scripts and manual testers are execute the test scripts...IS IT RIGHT OR NOT?
Hi, I am using 2 excel sheet.First excel sheet works fine with the script, if it opens the 2nd excel sheet,it works fine,but after finish all the rows it is giving the following error in the following line. InValid Procedure call or argument Line (178): "Browser("name:="&result,"application version:=internet explorer 7").Page ("title:=bgt.*", "index:=0").WebList ("name:=SearchType","html id:=Select1","location:=0").Select SearchType1". I have seen a web article says that,If we use any vbscript friendly name it may gives the above error-Invalid procedure call or argument not sure,Am I using any VBScript frienlyName? in the above line? [but the same line is perfecly working for first Excel ] It is little urgent. Any Help Thanks you
I want to grow as a Automation Engineer,Kindly help me in clearing my interview that what interviewer looks for as a Automation Engineer. I am having three years of experience in testing.
what is Synchronization point in QTP?Can anybody give a perfect example on it Thanks in advance
There is a name "AJAY" how do u count no.of. "A" in that name ?
Types of properties that Quick Test learns while recording?
Can we directly automate testscripts accrdoing to requirements? WHY ?
How QTP recognizes Objects in AUT?
There r 1000 rows and 1000 coloums , in that I want pickup a name of the coloumn , pls dont say in sql statements , in interview one of the interviewer said it was a wrong answer pls any send me answer its urgent
Please Don't mind .i want in detail the real time process i.e in each document what it contains.
What is Optional step?