*prune*
>If the structures (including data types) and range of records are the same. All you'd need to do is iterate through the fields and compare each field. Of course, you'd have to track which records were changed. *** snip *** Naturally, this would be inside a SCAN...ENDSCAN structure.
Doug,
If only the data content gets updated (and not the number of records) and if there is a common key that does not get changed by your test run, then things become incredibly simple:
SELECT * FROM TableOne ;
UNION ;
SELECT * FROM TableTwo
If the resulting cursor (or table) RecCount() has increased then there are rows with duplicate keys. Do another SQL select where CNT(Key) > 1. This should result in only those records where data has changed - hopefully reducing the work involved in locating the changed data.
censored.