The method I use to update a DB structure is basically copying the DB container, and then doing APPEND FROM for each table.
Parent tables have to be copied before child tables. Get the information from the DB, with ADBObjects(). You can ignore relations where the the third character of the relation = "I" (ignore).
The update works much faster if you use COPY FILE for tables whose structure didn't change, but this is a little more complicated.
Hilmar.
>Hi
>
>I need a way of using APPEND PROCEDURES in a class object.
>
>I've noticed that you can't use the command in compiled apps, but I need to alter 50+ standalone PC's with these DB Procedures .
>
>Any ideas ?
>
>Thanks
>Kev
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)