Comparing Recordsets in a Database | CodeGuru

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 […]

Written By
CodeGuru Staff
CodeGuru Staff
Sep 19, 2002
1 minute read
CodeGuru content and product recommendations are editorially independent. We may make money when you click on links to our partners. Learn More



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

CodeGuru Logo

CodeGuru covers topics related to Microsoft-related software development, mobile development, database management, and web application programming. In addition to tutorials and how-tos that teach programmers how to code in Microsoft-related languages and frameworks like C# and .Net, we also publish articles on software development tools, the latest in developer news, and advice for project managers. Cloud services such as Microsoft Azure and database options including SQL Server and MSSQL are also frequently covered.

Property of TechnologyAdvice. © 2026 TechnologyAdvice. All Rights Reserved

Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.