Comparing 2 tables in Delphi 1.0 or Reportsmith(sql)
Posted on 1997-10-17
I need to comapre 2 tables of same format(one old, one updated) the field values being yes/no. I need to produce a discepency report where only the unmatched fields are displayed.
I have an idea :
Take field values from both tables and place them in variables in Delphi then comparing them and outputting the unmatched variables to a new tempororay table that is eliminated after this report is generated.
How would you suggest that I solve this problem. Should I use Delphi 1.0 or should I use Reportsmith for processing.