Interested to Buy Any Domain ? << Click Here >> for more details...
hi,
In A Table there are some columns and dynamic rows and in each
row in first column there is a link with name. upon clicking on
that link it will show some details. write the vbscript to check
that link without descriptive programming?
- 2 Answers
- 12723 Views
- HealthAsyst, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kshama
I think the question asked was that you have to search for
"Testing" word from the name column.
Follow the below given steps:
1. prepare an excel sheet whose colums are dynamic and rows
are static.
2.Rename the "sheet1" with any name say for an eg:- "Data"
3.suppose excel sheet contains columns like Name, class and
section. and in "Name" column you have to search for the
word "Testing".
4.In Qtp write the following scipt.
datatable.addsheet"vital"
'Vital is the name of the virtual sheet in QTP'
datatable.importsheet"Pathe of the Excel sheet","Data","vital"
rc=datatable.getsheet("vital".getrowcount
MsgBox rc
For i=1 to rc
Dim a
a=datatable.value="Name","vital"
if a="Testing"
MsgBox "Testing"
Endif
Next
| Is This Answer Correct ? | 2 Yes | 3 No |
Answer / pramod mallick
I think, the table mentioned here is not Excel sheet. It is
a html table on a web page, where 1st colum contains links
with name="name".
So, the porblem is when you 1st record the script, there
are 2 rows (example) and 2 links with description = "name",
so, qtp object repository will add location property to
link (1st link = Location:0, 2nd Link = Location:1 etc..)
When you execute the script, there are 5 links with
name="name" (because of 5 dynamic rows added). Now, how do
you select /click other 3 links (3,4 and 5). Because, you
have only 2 Links recorded.
The 1st and best solution is descriptive programming. The
interviewer asked for without desriptiev programming.
The psedu code is given below.
-- Record only one link (with location:0)
Do
browser.page.frame.Link(location:0).Click
-- Change object description for Link, Update Location
to 1 instead of 0.
bExist = Browser(b).Page(p).Link.Exists
Loop While bExist = True
| Is This Answer Correct ? | 1 Yes | 3 No |
actuall wat my doubt is:while doin regression testin we enter all +ve & -ve data....system has to accept +ve and reject -ve data.in such case we get a popup window sayin that wrong entry...now i wan to overcome this popup window..how do i go further....plz explain.i tried thru rec.scenario but of no use.
i have to pass the testcases into userid anf password of gmail login page using functions you can take your own testcaseslike userdid should take only lowerletters it should not take special charactors and uppercase letters and password should take only numericvalues it should not take alphanumeric and alphabets
What is the extension of the qtp local repository?
hen do start automation testing after manual testing
How to capture data from images in QTP and produce them in Excel sheet ? please ans...
Discuss the QTP Environment?
Hi All, I need code for how to execute qtp scripts from excell sheet
what is the process to follow between writing the test cases & then atomating it?
Think and Reply.. can we parameterize radio buttons, check boxes? as in flight web site on flight preference page, choosing different flight produces trouble if from port and to port been parameterize, and runs. Try it by own you will get the error.
Write script to fetch the data from global sheet where row number is 3 and parameter is "text"
3 Answers Accenture, Thomson Reuters,
what is stepin & stepout?
Hi,can anyone tell me How to found the number of 1's and 2's in the given format 1,1,2,2,3,3,4,2 using vbscript Thanks in advance
WinRunner 
