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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only