Comparing Recordsets in a Database



Click here for a larger image.

Environment: VC6 SP4, NT4 SP6, ADO 2.5

Everyone knows this. You have a complex table structure in the database, and then you have to customize the software work and change this data. How do you compare and verify the results of the new version with the old? With this little tool, you can define a set of queries and its parameters (referenced in the query like $$parametername$$) and dump these results to a file. Two of these files can be compared with the program "WinDiff."

Tip: Look at the macros and the functions in the CAdoUti class.

Acknowledgements:

I used the CGridCtrl class from Chris Maunder, just because I thought it's the best. Thanks, Chris!!! (I have modified the grid to use it as a property sheet.)

Downloads

Download application - 80 Kb
Download source - 177 Kb


Comments

  • We had this but solve it differently

    Posted by Legacy on 09/23/2002 12:00am

    Originally posted by: Russ Freeman

    We had the same problem; Established DB and code to act on it...now the code needs to be changed and the data needs to be verified against the old code.

    We wrote some ASP pages that simply queried the two sets of data and produced web pages from the results of the comparison. It was quick to do and easy to see differences. Links were added to drill into the differences to better see why there were differences.

    Now, whenever we make such changes we run everything through the ASP pages.

    Works for us!

    Reply
Leave a Comment
  • Your email address will not be published. All fields are required.

Top White Papers and Webcasts

  • Live Event Date: May 18, 2015 @ 1:00 p.m. ET / 10:00 a.m. PT While the idea of using facial and or gesture recognitions to create a modern, intuitive game seems attractive, some developers may want to leverage Unity 3D as a way to accelerate their development. There are many different ways in which Intel and Unity Technologies have been working together to helps speed the develop of games with the Intel® RealSense™ SDK (Software Developer Kit), so come hear from a panel of experts on what we've done …

  • Live Event Date: May 6, 2015 @ 1:00 p.m. ET / 10:00 a.m. PT Where are you in your plans to adopt Disaster Recovery-as-a-Service? Are you just getting started? Fighting an uphill battle with management? At Cisco, Zerto and iland, we've seen it all – from the early adopters who excitedly rushed to implement DRaaS with us nine years ago to the IT folks dragging their business leaders into the future. With our years of experience, we've learned there are six types of DRaaS leaders – but which type …

Most Popular Programming Stories

More for Developers

RSS Feeds

Thanks for your registration, follow us on our social networks to keep up-to-date