if my application shows 100 records and in my database having 200 records how

if my application shows 100 records and in my database
having 200 records how i can validate using QTP tool?plz
exp. in detail?

Question Posted / chandana

2 Answers
5273 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

if my application shows 100 records and in my database having 200 records how i can validate using..

Answer / rakesh patwa

Also I want to add on Amarendra Kothuru's reply -

It depends on how you want to compare the record. However,
the easy approach could be -

Extract all the data from database into an excel sheet by
in ascending or descending order and compare it with
expected data. You can also highlight the mismatch data
using Excel Application COM.

You can send me email on rakeshpatwa at gmail dot com.

regards,
Rakesh

Is This Answer Correct ?

0 Yes

0 No

if my application shows 100 records and in my database having 200 records how i can validate using..

Answer / amarendra kothuru

It entirely depends on your application. If the developers
use Webtables to display these records, then the solution
depends on the Page size and no of Pages available for the
Web table.
I.e. For example If the page size is 50, it means, web
table page contains 50 records. If the total records
available in Database is 200 records, then The no of pages
of the web table should be four.

Total records = Page size * No of Pages in the web table.

So that you can verify the total number of records in your
application & in your database.

Is This Answer Correct ?

0 Yes

1 No

Post New Answer

More QTP Interview Questions

Hi all, On recording a particular Web application with QTP,Have came across a problem for which I havent found a solution so far.. The script of importance is as follows: Browser("Personalized Start Page").Page("XYZ").Frame ("mainFrame_4").Link("address.csv").Click Browser("Personalized Start Page").Page("XYZ").Sync Dialog("0% of dms.php from XYZ-").Dialog("File Download").WinButton("Save").Click My problem is that on recording the application with QTP and clicking the "address.csv" link another browser window comes up temporarily followed by the Windows "FileSave" dialog.The browser window which came up closes down when the Windows "FileSave" dialog is visible and I save the file to a windows location. On the "Record and Run" settings under Qtp,have activated settings for web and windows applications. But when I run this recorded script,and after the "address.csv" click,The browser window comes up and goes down,No Windows "FileSave" dialog comes up and the QTP shows the error Dialog("0% of dms.php from XYZ-") object is not found,though this object is there in the repository. Have tried putting the Dialog("0% of dms.php from XYZ- ").Exist property.But the "Exist" property is not recognised by the dialog at all. Any help in this direction is appreciated.. Thanks in advance J

1 Answers ADP,

Hi, How to give drop down values as input [Variable] from data table in QTP? If u know share with me.

3 Answers

What are objects? how do you select the unknow object?

3 Answers

Hi, I will provide perticular age,it needs to enter date in text box (MM/DD/YYYY) compare to system date. or already exist data in the text box.

2 Answers Virtusa,

does qtp runs on internet explorer 7.0

5 Answers BeBo Technologies,

What is the concept of firewalls?

2 Answers CTS,

please any one can explain the keyword driven framework. with gmail example.