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
4369 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