How can I verify particular fields from DB and get additional info about difference/change as compare with stored data?

Hello,

 

I am using Test complete first time.

 

My requirement is to verify data/ fields from data base by comparing that data with the baseline copy stored in your project"

 

 

There is a oracle table aoi22_tocinstance which has tocid,crcdate,qstr,status fields/columns.

After every work flow this table get updated.Hence I want to check updated fields after every workflow as per crcdate.

 

To achive this I saved this table in DBTable element in Store of Test complete application and defined tocid as a key,hence after every work flow I'll run the script which will compare the stroed dbelement values with Database value.

 

But when I run the script the result I am getting is wrong,

 as what I understood is that the test complete application comparision considering the worng row index to do comparision with Database.

 

 

To solve this I defined Key for all the fields, So Now the result of the Compar method is "Number of row is different than the stored number of rows". which is correct but not as per the expectation.

 

Hence I could not achive the functionality I required.

 

 

So How can I verify the QSTR, CRCDATE fileds from  data base by comparing that with stored db ? I also want additional info which shows the exact diffrence. I don't want to specify manual additional info.



Please provide comments on this.



Thanks,