Champion Level 3You want to use TestComplete to connect to a database to put values into an Excel sheet? Not sure I understand why. There are too many steps in here, I'm sure.
What are you actually trying to accomplish with your testing. Maybe we can find an easier way.
Marsha,
Right know what we do is we query the data base and find the accounts for our test data and manually add that in the keyword driven excel sheet under the value column.
What we are trying to achieve instead of manully querying and putting the data. We like to connet to our data base thru checkpoint and get the data and put those accounts (test data under value column in excel) while script is running.
Hope
I still wouldn't update the spreadsheet... doesn't make any sense to write it to the spreadsheet when you're using it in the same code.
In any case, what I would use for connecting to your database is utilize the ADO object in TestComplete.
https://support.smartbear.com/testcomplete/docs/reference/program-objects/ado/index.html
This will allow you to build and create queries and execute them accordingly.
Thanks martin,
Is there any better way we can handle this?
