Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Some RI ideas
Message
De
17/04/2007 15:27:16
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01216870
Message ID:
01216981
Vues:
13
>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform