Execute database query using onscreen value
We need to grab an onscreen value (confirmation number, ticket number etc) from web page and pass that value into a sql query to perform a database checks. So, i am using a project variables to capture the on-screen value.
Currently, i have to edit the db checkpoint and insert the value manually into the custom query page to perform back end validation using TestComplete.
For values that change every time the test case is executed (example - confirmation number) If we can automate the process of capturing the on-screen value from the variable and passing it to the query, the whole test case will become automated and reduce the need for manual intervention.
Are there any other approaches adopted by any other customers which might help solve this need?