Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Comparing two tables
Message
From
22/08/2009 17:50:16
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01419830
Message ID:
01419863
Views:
67
Sergey --

Looks to be like the download you referenced is not exactly what I am looking for -- it does a nice comparison of the structure of two tables, but, from what I am able to see, does not compare the actual data.

Will try XML and Beyond Compare next

>Jim,
>
>Check file #25036.
>Another option would be to convert tables to XML with CURSORTOXML() and use text compare utility of your choice. I would recommend BeyondCompare
>
>>I have copies of the same table as it existed last weekend and this weekend.
>>
>>Sometime between then and now, a number of fields for a number of records have been destroyed. At the moment I have no idea how this happened, which fields are involved, nor how many records got trashed.
>>
>>The file is of moderate size -- about 10,000 records for about 150 fields.
>>
>>Is there any handy utility that will help me identify changed fields and records between the two?
>>
>>Thanks in advance.
Jim Nelson
Newbury Park, CA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform