Forum Discussion

Nickolas's avatar
Nickolas
Occasional Contributor
3 years ago
Solved

How to update DBTable columns?

After each major section of my test cases, I run a DBTable Compare to check if the data was saved correctly by the application.   Sometimes, we have to remove/rename fields from the database and th...
  • anupamchampati's avatar
    anupamchampati
    3 years ago
    As far I know for editing the fields you have to go to store and edit the tables and select the fields, files are generally store in encrypted form so you won't be able to edit in outside any software.

    If fields are very often changing, you can maintain an input select or any query (may be in excel , text file or CSV) and use the scripting code to fetch input from this files and you can play with the output.
vinniew's avatar
vinniew
Staff
3 years ago

Hi Nickolas 

 

Hope you are well. 

 

Have you tried updating the store in TC? 

 

https://support.smartbear.com/testcomplete/docs/testing-with/checkpoints/stores/dbtable/updating.html

 

How often are these fields changing? or what is the reason for them to change? 

 

We could also access executing's this outside of TC, is there a shell script/script routine  that could be executed to achieve this? 

 

Not entirely sure if its possible but it would involve knowing how to change DBTable variables in a file and executing that as part of the script

 

Interested in other members feedback on this matter