Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Quick compare tables
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00743925
Message ID:
00744265
Views:
9
Hi Jeff.

>Anyone know of a compare function or other utility that will return whether two tables with the same structure contain exactly the same data in each field?

Someone (don't remember who) posted a simple way to do this in VFP 7 or later: use CURSORTOXML to convert each table to XML string, then do a simple IF lcXMLTable1 = lcXMLTable2. That would find any differences, including structure or content.

Doug
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform