>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").
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)