Forum Discussion

Raj48's avatar
Raj48
New Contributor
3 years ago

Compare two SQL query results data

Hi,

 

Is there any way to compare two SQL queries data in TestComplete through Database checkpoint? 

For ex:

SQL query 1 - DBTable1

SQL query 2 - DBTable 2

and then compare --> DBTable1 vs DBTable2

 

As i understand, DBCheckpoint will fetch and compare the results against base data. Not sure how to keep base data from SQL query 2 and compare it with SQL Query 1. 

 

Please suggest. 

 

Tried File Checkpoint already (by exporting the data from both the queries into different sheets and compare). Just want to know, if DBCheckpoint can help here.