Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table Comparing Utility
Message
 
 
To
13/12/2000 14:04:52
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00452816
Message ID:
00453016
Views:
24
>>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.
>
>I was waiting for you to add this Houston. Used it again just yesterday and it works beautifully. Many thanks again.
If you've added code to make things more generic and/or more sophisticated, then you might want to post it in the Files Section.
censored.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform