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?

Answers were Sorted based on User's Feedback



hi, In A Table there are some columns and dynamic rows and in each row in first column there is a ..

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

hi, In A Table there are some columns and dynamic rows and in each row in first column there is a ..

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

Post New Answer

More QTP Interview Questions

request to add whatsapp grp for test engineer

1 Answers  


Explain about reusable actions?

3 Answers   IBM,


How to fetch web elements count from Google Page which contains letter "e"

4 Answers  


i have an external excel datasheet where it only contains 3 rows. after qtp executed the code to import the datasheet, the datatable getrowcount method now gives me a different value, lets say 60,000+ instead of only 3. i did not have any values starting from row 4 of my excel file. why is this happening? this also results to the qtp report to load for a very long time.

0 Answers  


what is the purpose of .vbs file?

2 Answers   HCL,






In QTP if u got a defect , how to report to developer using Test director or Quality center .

5 Answers   Wipro,


how will you handle the situation when object is not caputred during record?

0 Answers  


How are actions and functions different in QTP?

0 Answers  


What is the difference between QTP 8.2 and QTP 9.2

1 Answers  


To which environments does quicktest professional (qtp) supports?

0 Answers  


Function to convert lowercase to uppercase in QTP Pls anybody can give the answer.. Thanks in advance...

2 Answers   Navis,


How do we call Library Files(.vbs) in the Test Script Thanks in Advance...

6 Answers  


Categories