Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Database update, best practices
Message
De
25/01/2002 19:28:37
Carol Dewar
Magram Computer Services Llc
Saugerties, New York, États-Unis
 
 
À
25/01/2002 10:57:45
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
Divers
Thread ID:
00610172
Message ID:
00610922
Vues:
22
WOW
I was looking for guidance on which way to go.
And you provide me with better code than I have written so far and a solution.

You are a mensch,
Carol Dewar

>>Have you automated this? done this remotely? Any "Lights out" problems? considerations?
>
>I will include my program; one thing I can't include, because it belongs to the framework I use.
>
>You will therefore need to provide the Table_Needs_Update() function. For a quick start, let it provide "new table" for new tables, and "there are changes" for all others. You can add commands to check for changes (and return "no changes" as appropriate) later.
>
>The basis for the following program is: create a list of tables, create a list of relations, loop through all tables and update them, postponing tables that are on the "child" side of a parent-child relation for the next iteration of the loop.
>
>HTH, Hilmar.
Carol Dewar
Magram Computer Services LLC
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform