| || |
Enhancing Database Checkpoint.
I am working on QTP 9.1. What I was trying is to test an Import utility, which imports data from an excel sheet to a sql server 2005 database. I have with me the original Excel file and the access to the Database.
I imported the excel file in QTP and also I am able to add a Database checkpoint successfully. Problem I am facing is that Database Checkpoint wizard lets me to specify, Expected data (from the Data sheet imported) for a single Cell only.
I have to select a single Cell and specify where QTP should look for the expected value. Now this technique I find very cumbersome. Please if you can suggest how can I reduce my script creation time. If the expected data can be given can be given column wise. I wont have to worry even if number of rows in the imported file increases.
Thanks and Regards,
Re: Enhancing Database Checkpoint.
Why not just to create a DB query and compare returned data set with expected (compare arrays)?