Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Some RI ideas
Message
 
 
To
17/04/2007 15:27:16
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01216870
Message ID:
01216986
Views:
16
>>I see. Yes, I may try to write something like that to apply structural changes. It also helps to eliminate deleted records.
>
>Actually, when the structure between the two versions doesn't change, the table gets copied through a COPY FILE, which is much faster. Of course, in this case deleted records would not get eliminated, so you may want a separate utility to PACK.
>
>On the other hand, checking whether the structure is identical is not trivial; you would have to check field names, types, validation rules, etc., and many more, I think. It is mainly here that I use a VFX function.

I wrote my own DataDictionary about 7 (!) years ago. I think I would not attempt to do it now <g>
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform