Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating data structure
Message
From
09/11/2004 11:27:13
 
 
To
09/11/2004 08:11:16
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00959460
Message ID:
00959599
Views:
8
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").
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform