Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Table Comparing Utility
Message
 
 
À
13/12/2000 14:04:52
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00452816
Message ID:
00453016
Vues:
25
>>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform