Forum Discussion
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?
- Marsha_R5 years agoChampion Level 3
Read it from the database as you need it rather than reading it from the spreadsheet.
- GAutomation5 years agoFrequent Contributor
Martha,
Thanks for Quick Reply. all other values are reading from Excel. if i read this value from data base. How will we put that data or enter into application that we are working on.
just first time working on this.
- Marsha_R5 years agoChampion Level 3
Use the ADO driver that tristaanogre mentioned to access the database data
https://support.smartbear.com/testcomplete/docs/testing-with/data-driven/drivers.html
It's similar to how you use Excel driver for the spreadsheet data.
Related Content
Recent Discussions
- 18 hours agoAivanitskiy
- 21 hours agonastester