Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DBC Comparison Utility
Message
From
16/10/1998 00:19:19
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00147286
Message ID:
00147355
Views:
31
>Does anyone know of a utility that will read a .dbc, return all of the tables, their structures, index tags (and expressions) and compare it to another identical .dbc identifying the differences.

I wrote a utility to do this a while back, but I can't put my hands on it right now. The idea is to use ADBOBJECTS to create arrays of tables and views. Then you have to loop through these and:
For table structure use the tables and use AFIELDS()
For index information, use TAGCOUNT() and SYS(14)

For views loop through your view array and use DBGETPROP to pullout you field list and whatever other information you want, all the while comparing the two sets of information you have.

This didn't take a terribly long time to put together, and you could probably give your routine more functionality than I gave mine, but if you want to keep hounding me, I'll see if I can dig it up...
Erik Moore
Clientelligence
Previous
Reply
Map
View

Click here to load this message in the networking platform