Novice user requesting help on DBTables compare
I'm a novice user and have a question regarding a test that I'm trying to do.
I'm attempting to record a keyword script that adds data to my local db, checks for that data stored in my local db, then deletes the record at the application level (not the database) and then checks that the record was indeed deleted. I've successfully have added and executed the script, so that it opens my application, enters the one item via the application into my db, and then deletes the record. The problem that I'm encountering is understanding how the data compare works.
I've converted my keyword test to a script and have established a connection to my local db via DBTables in the Stores section of TestComplete. However, it does not appear to be checking the values, but I could be misunderstanding how it functions. What I'm looking to occur in the log file is an indicator that the record has been added and what the value of the record added was. Then I would like to see some validation occur at the end of the test that checks to make sure that it was deleted.
Here is my script:
Call Aliases.abc.wndabc9c000000.abc9c000000.wndEthnicit ies.Click(256, 312)
Call Aliases.abc.wndabc9c000000.mrs9c000000.wndEthnicit ies.Click(256, 312)
Here is my db connection string using the custom query data source:
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=abc;Data Source=MIKEC-I1545
I watched the tutorial about Database Checkpoints, but I still must be doing something wrong.
Does anyone have any suggestions?
Re: Novice user requesting help on DBTables compare
Checkpoints can only report whether comparison passed or failed, and in case of a failure all differences are shown in the log or the Remarks panel. Checkpoints do not post information about what was added or deleted.
If you would like to have description of what was done by the test, you can post messages to the log containing information about the changes the test is doing.
To learn more about how the comparison works, refer to the 'How the Database Comparison Procedure Works' help topic: