Using Dynamic SQL in TestComplete DBTable
Our application data is completely refreshed every month, so the record values/keys change. Is there a way i can make the queries dynamic in the DBTable wizard. For e.g. I want to use something like ...
As noted in the documentation, "The DBTable object provides access to a copy of the stored data. In other words, changes that you make in tests will not apply to values and connection settings stored in the project. They exist only during the test run and will be lost after the test run is over."
Refer to https://support.smartbear.com/testcomplete/docs/testing-with/working-with-external-data-sources/databases/examples/index.html and extract the data into a csv file. You can then refer to the csv file to perform your test, and/or update the csv when required. Or you can store the data into Excel.
