First note that the grids and databases are not supported by checkpoints within Test Complete. I could not use them anyway because of the variation within the expected result.
I have an action that my AUT performs. I use DDT to connect to the database and create a table variable. In order to set the table variable's RowCount property to ensure enough rows to hold my data, I iterate through DDT Driver once to count rows. I then have to iterate through again to populate the columns in the table variable from ddt.
My test then performs some actions. I open another DDT Driver object to compare the data against the expected results and the original values stored in the table variable.
I have done this in a few parametrized procedures so I can do this across a bunch of actions in my AUT thereby confirming that they are acting on the data as expected.
If you know of a better way to do this, feel free to let me know!
Thanks
S