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?
Champion Level 3Read it from the database as you need it rather than reading it from the spreadsheet.
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.
