Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Mine will open up a dialog and let you select the tables, then modi comm the resulting text file of difference. Let me know if you are interested. There may be something more canned that does exactly what you need, but I couldn't find it recently in my searches.
>Jay
>
>Thanks for getting back. What I want is to compare 2 tables, side-by-side, record by record. If I detect any difference in one then I want simply to overwrite the matching rec in the other table with it.
>
>As such it would be great if this were a totally generic process, where I just need to feed the 2 tables.
>
>Background: I have my VFP tables and copies of them, in FoxPlus format, which are used by MapInfo GIS. Now the GIS tables can be interrogated with an "Infotool" that pops up details from a selected record/object on the map. Any of these details can be changed in my VFP app, and I do an update to the GIS tables when the mapping session is invoked, to ensure the latest data are displayed.
>
>Terr
>Thanks for getting back. What I want is to compare 2 tables, side-by-side, record by record. If I detect any difference in one then I want simply to overwrite the matching rec in the other table with it.
>
>As such it would be great if this were a totally generic process, where I just need to feed the 2 tables.
>
>Background: I have my VFP tables and copies of them, in FoxPlus format, which are used by MapInfo GIS. Now the GIS tables can be interrogated with an "Infotool" that pops up details from a selected record/object on the map. Any of these details can be changed in my VFP app, and I do an update to the GIS tables when the mapping session is invoked, to ensure the latest data are displayed.
>
>Terry
>
>>I have a utility that will compare two tables, record by record, field by field, and spits out the differences into a text file. The output is not the easiest to read, expecially if there are memo fields with lots of text in them, but it definately works. Is that what you had in mind?
>>
>>Update: Or you can create a quick report, send the output of each table to an ASCII file, then use something like BeyondCompare to see the difference in the text files, and export that to a nicely readable HTML file.
>>
>>
>>>Hi Vixens
>>>
>>>Is there a command or function or a ready-made that compares 2 records, say, same structure but in different sister tables? I want to quickly zip through two identical tables, checking if any of the fields are different. I've got a shed-load of tables to check so I don't want to be writing bespoke code to check evry field of each.
>>>
>>>Am I missing (or have i forgotten) something fundamental here?
>>>
>>>'ppreciate it
>>>
>>>Terry
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement