>>, doesn't it add autoinc keyword? If not add yourself.
>
>That's exactly what I don't want to do. I distribuite to my customers an upgrade application where all update jobs it's made by a program.
The following procedure is quite generic, and yet flexible.
Create a copy of the database where all tables have zero records.
At the client site, do an APPEND FROM for each table (from the client's current data, into your empty database). You will need to do some moving around, and use some temporary file locations.
For every strict parent-child-relationship, you will have to copy the parent table first. Get the information with adbobjects("relation"). "Strict" means that the third byte in the RI column is "R" (restrict).
You can either do all your changes in the empty database in the first place, or have a small program that ZAPs all tables before distribution.
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)
