Forum Discussion

Occasional Contributor

9 years ago

Validate the user input values in the Database

Dear Friends, Scenario is, I have saved records successfully and i want to validate the values are stored in the DB. Like saving a records and verify in the DB. User Name: Senthil Place: Coimbato...

Contributor

9 years ago

Hi kktsenthill,

I think that the easy way is creating new Variable in the project or in te test. Type DB Table and connect it to your DB. Something like the image at the bottom but i think that there are better ways reusin a function in a script.

take a look at this links:

How to connect SQL Server using TestComplete

Working With Databases Using ADO and BDE Objects

Execute SQL Statement Operation

2015_05_15_DB Table Variable.png

Related Content

Validate multiple values from Database.
5 years agochsekhar
how can I create dynamic checkpoints to validate database information?
7 months agoRafael03Valdez
adding assertions in soap ui to validate xml response tags with database values
7 years agovineethwip
json schema validation of null values
5 years agoswlinn
Compare multiple values from database against API response
4 years agoArunachalam_RM

Recent Discussions

Delay after pressing specific Key
2 hours agoSubhraDas
Connecting to license manager behind a home router?
Solved
20 hours agotramuntana
How to specify to not save Pictures into log files for some actions
Solved
20 hours agosimonaferrara
Log.Error supressing Log.Warning in Execution Summary
3 days agoRodm00011
TC15 Log Details shows # of tests with warnings/errors, not TC14's # of warnings/errors
3 days agothebick