Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Looking for differences...
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00445792
Message ID:
00446000
Vues:
41
This message has been marked as a message which has helped to the initial question of the thread.
Scan the first, seek the matching record in the second, then scatter both records to objects (Scatter name MyObjName). Then use CompObj to compare the two objects. If one field is different you'll get a FALSE return.

You'll also have to determine if there are records in the second table that are not in the first, but you can use SQL-Select for that

SELECT MyIDField from Table2 where MyIDField not in (Select MyIDField from Table1) into cursor curNotInTable1

HTH
Barbara

>I have two tables with identical structures and record counts. I need a quick way to extract the different rows from either table into a cursor or table. The differences might be a single field or more. Both tables have an integer PK and are in sync. Any thoughts? TIA
Barbara Paltiel, Paltiel Inc.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform