Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Diff Tables?
Message
De
16/02/2001 16:21:58
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00476751
Message ID:
00476823
Vues:
20
Steve,
There's a great tool called BeyondCompare which allows you to compare directories and files. There's an addon that allows you to compare tables in text format. Whenever I have to compare two tables, I COPY TO CSV and then call BeyondCompare. The tool allows you to define the key field and displays the differences side by side. Brilliant tool, use it almost every day.

You can download an evaluation copy at www.scootersoftware.com

HTH

>I just got hit with an "emergency", where there are some suspected differences between different versions of a table.
>
>What I am doing is creating an array, loading all aliases into the array, and then setting up a FOR...NEXT loop to do SQL with the current table versus array posistion -1.
>
>I was trying to use macro substitution for the table names and am messing something up, since things are moving very s-l-o-w-l-y. Does anyone have any "guaranteed diff" code laying around?
Daniel
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform