Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Database update, best practices
Message
From
25/01/2002 19:28:37
Carol Dewar
Magram Computer Services Llc
Saugerties, New York, United States
 
 
To
25/01/2002 10:57:45
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00610172
Message ID:
00610922
Views:
21
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform