Forum Discussion

MikeFinch's avatar
MikeFinch
New Contributor
12 years ago

Means to use a Table Checkpoint to verify grid content against DB source

Hi,



(Running TestComplete 8.7)



Our application uses a SQL DB and displays the content via DevExpress XtraGrid GridControls to the user.  Is there any means to populate a DB Store in TestComplete and use that as the source for comparison against a Table Checkpoint, or vise verse?



Ultimately, one of the goals is to verify that the content in the application grid view, before and after the application runs calculations, matches the content in the DB.  I can't seem to find any way to point the Table Checkpoint to a DB Checkpoint source.



Thanks for any assistance.

2 Replies

Sort By
  • HKosova's avatar
    HKosova
    SmartBear Alumni (Retired)
    12 years ago
    Hi Mike,



    Certainly, you can do this with a little bit of scripting.



    TestComplete lets you modify the baseline data of a table checkpoint using the TableCheckpoint.Values property. So, you could write a script that would read data from the database (see an example here), modify the checkpoint's data appropriately, and then execute the modified checkpoint.



    In addition, comparing a grid against a database seems to be a good idea for a built-in checkpoint, so I've logged a feature request for this. Thanks for the idea!
    • hlopez_ict's avatar
      hlopez_ict
      New Contributor
      8 years ago

      Hi Helen. do you guys have any progress in this? comparing a grid against a database, or is it any other way to do this