Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Updating data structure
Message
De
09/11/2004 11:27:13
 
 
À
09/11/2004 08:11:16
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
00959460
Message ID:
00959599
Vues:
9
That's just was I Did, what I want to implement was something which could check if the Data structeres had changed.
I thought to test if the exe program had changed but Is not sure that Data structure change with a new compilation of the Application...


>>I was thinking about a procedure which allows me to update automatically tables and database informations.
>>Anyone else has already thought something like that (of course he has ..)?
>>Thank you
>>Alessio
>
>Make all your structural changes in an empty database: all tables have zero records.
>
>Have a small program that makes an APPEND FROM for each table (combining the empty, new, structure, with the data in the old structure).
>
>Watch out for RI: if the third part of the RI information is "R" (restrict), parent tables have to be copied before child tables - or else, if you copy the child first, you get a "trigger failed" message. Get the information about the relations with AdbObjects("relation").
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform