Forum Discussion

Kateryna's avatar
Kateryna
Contributor
14 years ago

Getting SQL Query in the script

Hello, Is it possible to get SQL query during test execution with the help of the script? For example I have DBTables with Table1, Table2 and Table3. And during test execution I need to writ...
TanyaYatskovska's avatar
TanyaYatskovska
Icon for Alumni rankAlumni
14 years ago

Hi Kateryna,


 


I see. A DBTable checkpoint allows using custom queries, but do not allow getting/modifying the query from the script. So if you need to verify results of a dynamic SQL query, you will have to implement the needed data retrieval and data comparison code manually. To learn how to work with databases in TC, see the"Working With Databases" article.


 


BTW, we have a corresponding suggestion in our DB and your request has increased its rating.