Contributions
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.Solved967Views0likes2CommentsSearch for particular content in Text File
Hi, This is regarding content search in Text File. I have a Daily Settlement Text file which has previous day transactions (approx 100 lines with transaction date and type).Is there any better way to search for a particular transaction (from the entire file) and validate the variable details (for ex: Amount in the below format). I tried with aqTextFile.ReadLine/ ReadToSymbol. For some reason, its not helping. Should i go for any regular expression here for searching the unique combination? (transaction date + Transaction Type) Ex File format: Transaction Type: TXN1 Date and Time: 12-May-2021 Transaction details: Type 1 Transaction Amount: $4 Agent name: Test Agent Transaction Type: TXN2 Date and Time: 12-May-2021 Transaction details: Type 2 Transaction Amount:$8 Agent name: Dummy Agent Transaction Type: TXN3 Date and Time: 12-May-2021 Transaction details: Type 3 Transaction Agent name: Sample Agent Amount:$48Solved640Views0likes1Comment